Skip to main content
Skip table of contents

Installing Microsoft SQL Server 2014 or 2019 Express with Management Tools to MYOBACCT Instance

This support note applies to:

  • AE Practice Manager (AU)

  • AE Tax (NZ)

  • AO Corporate Compliance (AU)

  • AE Tax Series 6 & 8 (AU)

  • AE Tax (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 33977

These instructions are only for SQL Express installations.

Following is information regarding how to install SQL Express 2014 or SQL 2019 Express with Management Tools to the MYOBACCT instance with mixed authentication and configure options.

Installing Microsoft SQL Server 2014 Express with Tools

  1. Ensure you have the prerequisites installed:
    .NET framework 3.5 SP1
    .NET framework 4.5
    Powershell 2.0
    Windows Installer 4.5

    If you have an earlier version of Management Studio remove this first via add/remove or programs and features.

  2. Run the following:

    • To install 32 bit version of SQL Server – SQLEXPRWT_x86_ENU.exe, or

    • To install 64 bit version of SQL Server – SQLEXPRWT_x64_ENU.exe.

    MYOB recommends that you use the links below to the relevant installation.

    For 2014: Microsoft® SQL Server® 2014 Express
    The SQL Server Installation Center window appears.

  3. Click New installation or add features to an existing installation link. The Installation Type window appears.

  4. Leave the default option New Installation or add shared features selected and click Next. The Licence Terms window appears.

  5. Select I accept the licence terms option and click Next. The Feature Selection window appears.

  6. Ensure Database Engine Services and Management Tools - Basic is selected and click Next. The Instance Configuration window appears.

  7. Select Named Instance, change from SQLExpress to MYOBACCT, change the instance root directory if needed and click Next.

  8. Ensure both SQL Server Database Engine and SQL Server browser have an Account Name selected from the dropdown menu. For example: NTAUTHORITY\SYSTEM.

  9. Ensure both SQL Server Database Engine and SQL Server browser have the Startup Type set to Automatic for and click Next. The Database Engine Configuration window appears.

    Disregard the Collation tab. 

  10. Select Mixed Mode, enter the username and password. Click Next. The Error Reporting window appears.

  11. Click Next. The Installation Progress window appears.

  12. The Complete window appears click Close. The installation is complete.

Installing Microsoft SQL Server 2019 Express and Microsoft SQL Server Tools 18

Installing Microsoft SQL Server 2019 Express

  1. Ensure you meet the SQL Server 2019: Hardware and software requirements.

    If you have an earlier version of Management Studio, remove it first via add/remove or programs and features.

  2. Run SQLEXPR_x64_ENU.exe.

    MYOB recommends that you use the links below to download the relevant SQL Express installation.

    SQL Server 2019 Express –SQL 2019 Express Download.
    The SQL Server Installation Center window appears.

  3. Click New SQL Server stand-alone installation or add features to an existing installation link. The Installation Rules windows appears.

  4. Click Next. The Installation Type window appears.

  5. Leave the default option Perform a new Installation of SQL Server 2019 selected and click Next. The Licence Terms window appears.

  6. Select I accept the licence terms and click Next. The Feature Selection window appears.

  7. Ensure Database Engine Services is selected and click Next. The Instance Configuration window appears.

  8. Select Named Instance, and change Named instance and Instance ID from SQLExpress to MYOBACCT.

  9. Click Next. The Server Configuration windows appears

  10. Ensure both SQL Server Database Engine and SQL Server browser have an Account Name selected from the dropdown menu. For example: NTAUTHORITY\SYSTEM.

  11. Ensure both SQL Server Database Engine and SQL Server browser have the Startup Type set to Automatic for and click Next. The Database Engine Configuration window appears.

    Disregard the Collation tab.

  12. On the Server Configuration tab select Mixed Mode and enter the password.

  13. Click the Data Directories tab, change the instance root directory or other directories if needed and click Next. The wizard continues.

  14. The Complete window appears click Close. The installation is complete.

To install Microsoft SQL Server Tools 18

  1. Run SSMS-Setup-ENU.exe.

    MYOB recommends that you use the links below to download the relevant installation.


    SQL Server Management Studio – SSMS Setup Download. The Installation window appears.

  2. Click Install. The Installation begins and the Installation Progress window appears.

  3. When the Setup Completed window appears, click Close. The installation is complete.

Configuring protocols for Microsoft SQL Server 2014/2019

  1. Go to START > Programs > Microsoft SQL Server 2014/2019 > SQL Server Configuration Manager. The SQL Server Configuration Manager appears.

  2. Expand SQL Server Network Configuration. The Protocols for MYOBACCT option appears.

  3. Click Protocols for MYOBACCT. The Protocol Name and Status columns appear.

  4. Right-click Named Pipes and select Enable. A warning window appears.

  5. Click OK. Named Pipes are enabled.

  6. Right-click TCP/IP and select Enable. A warning window appears.

  7. Click OK. TCP/IP is enabled.

  8. Click SQL Server Services in the left-hand pane. A list of SQL Servers appears.

  9. Right-click SQL Server (MYOBACCT) and select Restart. The service is restarted.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close