SQL server 2019 upgrade guide

This support note applies to:

AO Tax (AU & NZ)
MYOB AO Practice Manager (AU & NZ)

Microsoft will stop supporting SQL 2014 from July 2024. If you use AO with SQL 2014, it is time to upgrade your SQL.
We’ve developed a utility to help you upgrade from SQL 2014 to SQL 2019.

Pre-requisites

SQL 2014 version: This utility supports SQL 2014 32-bit version.
AO version: You must be on AO version 5.4.50 or later.
Operating system: Windows 10 TH1 1507 or greater, Windows Server 2016 or greater,
and 64bit.
Backup: Back up your AO database.
Windows updates: There will be multiple reboots during the upgrade so we recommend you install any Windows updates before running the utility.
Hard disk space: Make sure that there is enough hard disk available to be able to complete the upgrade.
Downloading the utility file: You must download and save the utility file on the local drive(C:\) and not on a network drive.
Disable Antivirus: Make sure your antivirus software is turned off during this process and remember to turn it back on after the upgrade
No users in MYOB applications: Make sure no one is using MYOB during the upgrade.
Upgrade time: This process will take some time (at least 30 minutes or more) depending on the size of your database.
System administrator (sa) SQL user default password: If you’re still using the default MYOB password for the System administrator (sa) SQL user, you’ll be prompted to change it during the upgrade. Once you’ve changed the password, make a note of it somewhere. We do not have access to that password after you’ve changed it.

There will be multiple reboots of your server during the upgrade process. Be aware that if you’re running any other non-MYOB programs on the same server, it might be affected.

Upgrading from SQL 2014 to SQL 2019

This utility must be run on the server where the SQL database is. Make sure the user you’re logged in on the server has administrative rights to run this utility.

This process will take some time (at least 30 minutes or more) depending on the size of your database.

Contact support to get a copy of the SQLServerUpgrade_V1 utility file.
Extract the file to the C:\. Do not extract it into a shared network drive.
From the SQLServerUpgrade_V1 folder, double click the SQLServerUpgrade_V1.exe to start the utility.
The utility runs through several steps:
1. Precheck - This is to make sure your environment is compatible.
2. Backup databases - The databases are backed up to the default SQL folder - C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.MYOBACCT\MSSQL\Backup.
3. Uninstall SQL 2014.
4. Install SQL 2019
5. Install SQL Server Management Studio
6. Restore the databases.
7. Configuring database settings
If we detect that you’re using the default MYOB password for the System administrator (sa) SQL user, you’ll be prompted to change it.

We do not have access to the System administrator (sa) SQL password once you’ve changed it. Make sure you document it in a safe place.

Post upgrade checks

Check the following to confirm that the upgrade to SQL 2019 is successful.

Create a new client in MYOB AO and make sure you can create a tax return for this client.
Check integration by changing client details and make sure that you see the changes on the tax return.
Open any tax return from AO and perform a lodgement.
Take a backup or schedule a backup in AO.
If you use Corporate Compliance, check to see if you can still access it.
If you had SQL users other than MYOBAdmin, vpmuser, and System Administrator (sa), you’d need to recreate them. These users interact with SQL for services such as scheduled backup, and MYOB SBR Sender Service. Failure to re-create them will impact these services.

AO Classic only: When you make any changes to client or contact details in AO Classic or AO, they will not integrate with each other. This includes any new changes and changes to existing details. You’ll need to update the details in AO and AO Classic separately.
See Changes in AO after upgrading from SQL 2014 to SQL 2019 (NZ only) for more information.

Troubleshooting

Errors during pre-check

After you’ve fixed the errors, run the utility file again.

Error message		Solution
Can't start application. Upgrade only supported for 32-bit SQL 2014.		The utility supports only from 32-bit SQL Server 2014 to 64-bit SQL Server 2019.
Wrong server to start SQL upgrade.		You must run the utility on the SQL Server environment that has the MYOBACCT instance.
Your environment isn’t eligible for an SQL server upgrade due to the following reasons: … … Follow the upgrade support steps or contact MYOB Support.	operating system version isn't supported	You must be on: Windows 10 TH1 1507 or greater or Windows Server 2016 or greater and 64bit.
	You're using a domain controller	For security reasons, we can’t install SQL Server 2019 on a domain controller. Contact your IT to remove the Domain controller server.
	Windows operating system has case sensitivity enabled	SQL Server is not supported on a Windows operating system where sensitivity is enabled. See https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-not-supported-in-windows-os-where-case-sensitivity-enabled to disable the case sensitivity.
	The hard disk available space is under xx GB	We require xx GB to complete the SQL upgrade, please free up space and run the utility again.
	The hard disk section size isn't 512 bytes or 4 KB	SQL Server currently supports sector storage sizes of 512 bytes and 4 KB. See https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size to fix the issue.
	The memory size is less than 2GB	SQL Server Management Studio requires 2 GB of RAM. Increase the memory and re-run the utility.
	CPU speed isn't qualified	SQL Server requires: Minimum: x64 Processor: 1.4 GHz SQL Server Management Studio requires: 1.8 GHz or faster x86 (Intel, AMD) processor
	CPU type you use isn't supported	Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.
	Unable to stop MYOB services	One of the MYOB Services has failed to stop. Follow the steps below to fix the issue and run the tool again. To check which MYOB Service has failed to stop, go to SQLServerUpgrade - V1.log file located in the same folder as the exe file. It can be of these services: MYOB Backup Service MYOB DM Portal Sync Service MYOB Tax Manager Service MYOB Workstation Auto-Updater MYOB Tax SBR Sender Server System Release DAL MYOB DMFS Service MYOB Indexing Service MYOB OnTheGo API Service MYOB Sync Client Service On the server, open the Services: Start > Control Panel > Administrative Tools > Services Change the Startup Type to Manual in Properties Run the utility again.
	AO or some background services are still running	Log out of AO if it’s still running. Check if any of the files are in use and close them. See Releasing open files ClientFrameWork.exe PmPlusConfig.exe MYOB.AF.BusinessEntities.dll MYOB.AF.DataAccess.Linq2Sql.dll MYOB.AF2.BusinessLogic.dll MYOB.AF2.DataAccess.dll MYOB.Tax.BusinessEntities.dll MYOB.Tax.BusinessLogic.dll MYOB.Tax.DataAccess.dll MYOB.Tax.DataAccess.Linq2Sql.dll MYOB_Tax_Homepage.dll AERego.exe SR.exe SR64.exe ds6tt090 IpSbr\Bin\MYOB.Sbr.dll
	SQL Server has other database(s) other than the AO required databases	This utility upgrades only MYOB related databases in SQL Server. Remove the non-MYOB databases and run the utility again.
	Unable to verify SQL Server user passwords	If you’re not using the MYOB default passwords for System Administrator (sa), vpmuser and MYOBAdmin. We need you to verify passwords to continue with SQL Server upgrade. Please try again if this step fails.

Errors during the upgrade

General Error (Step)	Detailed Error	Solution
Your SQL Server 2019 installation is complete however we’re unable to configure your databases and environment for the following reasons Follow the <upgrade support steps> or contact MYOB Support.	couldn't unlink AO Classic	Contact Support to fix this issue for you.
	(AU only) couldn't link AO Tax Server	To fix the error: Go to Maintenance > Tax > Tax Settings >Tax Connection > Connect to Tax database.
	couldn't delete DB identifier	Contact Support to fix this issue for you.
	couldn't start MYOB services	We need to restart the MYOB related services and set them to start Automatic or Automatic (Delayed Start) upon a server restart. To check which MYOB Service has failed to start, go to SQLServerUpgrade V1.log file located in the same folder as the exe file. On the server, open the Services: Start > Control Panel > Administrative Tools > Services Change the Startup Type is set to the following. MYOB Backup Service - Automatic MYOB DM Portal Sync Service - Automatic (Delayed Start) MYOB Tax Manager Service - Automatic MYOB Workstation Auto-Updater - Automatic MYOB Tax SBR Sender Server - Automatic (Delayed Start) System Release DAL - Automatic MYOB DMFS Service - Automatic MYOB Indexing Service - Automatic MYOB OnTheGo API Service - Automatic (Delayed Start) MYOB Sync Client Service - Automatic (Delayed Start)
	couldn't update password for 'sa'	If you are using a default System Administrator (sa) for your MYOB AO SQL databases, we recommend you to change the password to keep your data safe. If this steps failed, you can manually run a utility to change the password again: Changing the default password for 'sa' username in SQL
	(AU only) couldn't configure Corporate Compliance	If you still use Corporate Compliance for data lookup purposes, contact support to re-configure the users for you.