Installing Microsoft SQL Server 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.

The following is information regarding installing SQL 2019 Express with Management Tools to the MYOBACCT instance with mixed authentication and configuration options.

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

Installing Microsoft SQL Server 2019 Express

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.
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.
Click New SQL Server stand-alone installation or add features to an existing installation link. The Installation Rules windows appears.
Click Next. The Installation Type window appears.
Leave the default option Perform a new Installation of SQL Server 2019 selected and click Next. The Licence Terms window appears.
Select I accept the licence terms and click Next. The Feature Selection window appears.
Ensure Database Engine Services is selected and click Next. The Instance Configuration window appears.
Select Named Instance, and change Named instance and Instance ID from SQLExpress to MYOBACCT.
Click Next. The Server Configuration windows appears
Ensure both SQL Server Database Engine and SQL Server browser have an Account Name selected from the dropdown menu. For example: NTAUTHORITY\SYSTEM.
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.
On the Server Configuration tab select Mixed Mode and enter the password.
Click the Data Directories tab, change the instance root directory or other directories if needed and click Next. The wizard continues.
The Complete window appears click Close. The installation is complete.

To install Microsoft SQL Server Tools 18

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.
Click Install. The Installation begins and the Installation Progress window appears.
When the Setup Completed window appears, click Close. The installation is complete.

Configuring protocols for Microsoft SQL Server 2014/2019

Go to START > Programs > Microsoft SQL Server 2019 > SQL Server Configuration Manager. The SQL Server Configuration Manager appears.
Expand SQL Server Network Configuration. The Protocols for MYOBACCT option appears.
Click Protocols for MYOBACCT. The Protocol Name and Status columns appear.
Right-click Named Pipes and select Enable. A warning window appears.
Click OK. Named Pipes are enabled.
Right-click TCP/IP and select Enable. A warning window appears.
Click OK. TCP/IP is enabled.
Click SQL Server Services in the left-hand pane. A list of SQL Servers appears.
Right-click SQL Server (MYOBACCT) and select Restart. The service is restarted.

NZ AO only

There will be changes to AO Classic GL connection after installing SQL 2019. See Changes in AO after upgrading from SQL 2014 to SQL 2019.