question

JMN-2253 avatar image
0 Votes"
JMN-2253 asked SeeyaXi-msft edited

Install SQL 2012 on Windows Server 2019.

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://docs.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

azure-sql-virtual-machinessql-server-migration
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JanNuaman-2253 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·

Hi
In fact, the 2 response conflict with each others, that's made me more concern, uncomfortable!

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft edited

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:
147077-1.png
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:
147193-2.png

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



1.png (46.3 KiB)
2.png (79.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

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://docs.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--

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.