Microsoft SQL Server 2019 Compatibility Statement
This support note applies to:
- AE Tax Manager (NZ)
- AO Classic (NZ)
- AO Tax (NZ)
- AE Tax (NZ)
- AO Assets Live (NZ)
- AE Assets Live (NZ)
- AO Assets Live (AU)
- AE Assets Live (AU)
- AE Statutory Reporter (NZ)
- AE Statutory Reporter (AU)
- AO Statutory Reporter (AU)
- Workpapers (NZ)
- AO Workpapers (AU)
- AE Workpapers (AU)
- AO Practice Manager (NZ)
- AO Practice Manager (AU)
- AE Practice Manager (NZ)
- AE Practice Manager (AU)
- AE Document Manager (NZ)
- AE Document Manager (AU)
- AO Document Manager (AU)
- AO Classic Document Manager (AU)
- AO Classic Document Manager (NZ)
- AO Document Manager (NZ)
- PDF Manager (AU)
- PDF Manager (NZ)
- AE System Release (NZ)
- AE System Release (AU)
- AE Reporter (NZ)
- AE Reporter (AU)
- AE MAS (NZ)
- AE MAS (AU)
- AE Assets (AU)
- AO Corporate Compliance (AU)
- AE Assets (NZ)
- AE Corporate Compliance (AU)
- AE Accounts (AU)
- AE Investments (AU)
- Insolvency (AU)
- AO Classic Tax (AU)
- AO Classic Practice Management (AU)
- AO Classic General Ledger (AU)
- Profiles (AU)
- AE Tax Series 6 & 8 (AU)
- AE Tax (AU)
- AO Tax (AU)
As part of our environment compatibility process, MYOB has tested and evaluated the use of Microsoft SQL Server 2019 with the latest versions of MYOB products.
A standard installation of the latest versions of MYOB products was performed on Microsoft SQL Server 2019 and basic functionality for each product was tested.
The compatibility testing on SQL Server 2019 has been completed for most products and subject to conditions listed below; MYOB certifies the use of these MYOB products (latest version as at October 2020 or newer unless specified below) with Microsoft SQL Server 2019.
Importantly, SQL 2019 is only available as a 64 bit technology. In order to use SQL 2019, a 64 bit operating system is required. If you have compatible products and you wish to upgrade to SQL 2019, MYOB can assist though our SQL Instance Migration service. Please contact your MYOB Account Manager for more information.
Please refer to Error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server" for important information on setting Firewall exceptions to allow for SQL communication to the MYOB suite.
Products Compatible with SQL Server 2019 | |||
|---|---|---|---|
Product | Status | Minimum version | KB article |
MYOB AE Practice Manager | Compatible | 5.4.36* |
|
MYOB AE Document Manager | Compatible | 5.4.36* |
|
MYOB AE Tax | Compatible | AU 2020.1* NZ 2020.2* |
|
MYOB AE Tax Series 8 & Series 6 | Compatible | 8.32 SP1* |
|
MYOB Timecost Series 8 | Compatible | 8.32 SP1* |
|
MYOB Corporate Compliance (AU only) | Compatible | 3.2.0.5x* |
|
NZ Tax Manager | Compatible - see KB's for important information | 5.4.36* | |
Insolvency | Compatible |
|
|
Products Not Compatible with SQL Server 2019 | |||
Product | Status | ||
Alerts | Status Pending | ||
MYOB AO | Not Compatible - SQL 2014 Express 32 bit only | ||
MYOB AE integrated with AO Classic | Not Compatible - KB 38531 | ||