Install SQL 2012 on Windows Server 2019.

Question

Hi folks,

I've requirements to install SQL Server 2012 as I need to migrate SQL 2005 DBs, while going through this lovely article:
https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
I found that I can Install SQL 2012 on Windows Server 2019 when meeting 1 condition which is having SQL 2012 SP4 Installed.

I'm concerned about the installation sequence, so, is it okay to do below installation steps:
1- Install Windows Server 2019
2- Install Microsoft SQL 2012
3- Install Microsoft SQL 2012 Service Pack 4
4- Full Update for Windows Server 2019

I am afraid of being blocked from installation at first, or end up in non-supported scenario, since my SQL 2012 was not installed onto Windows Server 2012 at first place.

Your feedback is highly appreciated.

Thanks

Answer 1

Hi @JanNuaman-2253

Because I am not familiar with Windows Server(I am more familiar with SQL Server), I made a mistake before. I am sorry that my answer confused you and I have revised my answer. Luckily you didn't apply my answer first. Sorry again.
And thanks to LimitlessTechnology-2700.

First, this is the content of your document:

Secondly, we see that the link posted by LimitlessTechnology-2700 is Windows Server 2019 and Microsoft Server Application Compatibility. Among them, the SQL Server version supported by Windows Server 2019 is only the version after 2014.
Then we check Windows Server 2016 and Microsoft Server Application Compatibility. The contents are as follows:

So the final solution is to choose INSTALL SQL 2014(or later) on Windows Server 2019 or INSTALL SQL 2012 on Windows Server 2016

Here is the link about how to upgrade SQL Server from 2005 to 2014:
https://social.msdn.microsoft.com/Forums/aspnet/en-US/e84ca21a-db8c-4388-898e-c10e605271ac/how-to-upgrade-sql-server-from-2005-to-2014?forum=sqlexpress

Lastly, have a lovely day!

Best regards,
Seeya

Answer 2

Hi @JanNuaman-2253,

I found that I can Install SQL 2012 on Windows Server 2019 when meeting 1 condition which is having SQL 2012 SP4 Installed.

Make sure that you check known setup issues when you install SQL Server 2012 on Windows 10 or Windows Server 2016.
Here is a link about SQL 2012 SP4.
You cannot choose Windows Server 2019 the reason has been mentioned by LimitlessTechnology-2700.
OR you can choose a high version of SQL Server.

I've requirements to install SQL Server 2012 as I need to migrate SQL 2005 DBs

Please see this thread about migration:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f7ea18c6-27ba-4594-aae5-038442618d66/migration-of-sql-server-2005-to-2012?forum=sqlservermigration

Finally, I wish you success.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hello @JanNuaman-2253

as far as I know SQL Server 2012 SP4 is not officially supported on Windows Server 2019

Supported Operating System
Windows 10, Windows 7, Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

Here in "Windows Server 2019 and Microsoft Server application compatibility"

https://learn.microsoft.com/en-us/windows-server/get-started/application-compatibility-windows-server-2019

,you can full list of Microsoft Server apps that are supported on 2019. SQL 2012 is not on there, and according to some other documentation I've found, SQL 2012 is only compatible with Server 2008 (plus R2) and Server 2012 (Plus R2).

Hope this helps with your query!

---------
--If the reply is helpful, please Upvote and Accept as answer--