SQL 2014 to 2019 Migration Utility on DC
Hi All, MYOB has been pushing the upgrade to SQL Server 2019 with emails to the client fairly regularly, however I note that the download has been pulled from MYOB's download page a couple of tim...
Forum Discussion
Hi everyone,
For the sake of clarify, MYOB does not explicitly prevent the installation of SQL 2019 on a Domain Controller, however it is not recommended from a security perspective by Microsoft.
Microsoft's own SQL installer (which our SQL upgrade utility uses) does not prevent the installation of SQL on a Domain Controller.
Our SQL 2014 - 2019 Upgrade utility not only runs the Microsoft provided SQL 2019 installer, and upgrades your 2014 instance to 2019, but also does a number of other steps as well.
The upgrade utility will block an upgrade on a Domain Controller because of security complications that can occur with SQL on a Domain Controller - including, but not limited, to services that need to interact with the SQL server may not be able to without permission changes and so on. It's important to note that much of this is beyond the scope of MYOB support.
As such, the tool - out of the box so to speak - does not allow a direct upgrade.
I've written a KB on this that is currently in the process of being published - once It's published, this will cover off the steps you can take to use the SQL Upgrade utility to upgrade your SQL instance on a Domain Controller.
I will post the link to this thread as soon as it's ready.
