none
SQL Server 2012 compatibility with Windows Server 2016 RRS feed

  • Question

  • I have been looking all over the place for some related info regarding SQL Server 2012's support for Windows Server 2016 but have been unable to find any information so far.

    Does anyone know if SQL Server 2012 with SP3 is officially supported on Windows Server 2016? I need to create an instance of SQL Server 2012 running preferably on Windows Server 2016. As much as I'd like to use the newer version of SQL Server (2014, 2016), at this stage I am not able to do it. The Vendor (as of now) certifies the software only for SQL Server 2012 SP2+ or Oracle. I'd would dearly like to avoid Oracle if possible :-). 

    I know that I can use Windows Server 2012 R2, but the sysadmins are keen on using Windows Server 2016 if possible. 

    Thanks

    Wednesday, October 26, 2016 7:22 AM

Answers

  • I know about the document. However it seems to be dated. 

    I get it, the document doesn't mention Windows Server 2016 (most probably due to the fact that it was last refreshed before Windows Server 2016 was released.)

    Can you please point to an official document from Microsoft that states that SQL Server 2012 is not or will not be supported on Windows Server 2016?

    My understanding of the platform support policy was that SQL Server will generally be supported on at least 2 OS platform which are released after the SQL Server bits get released. For example SQL Server 2008 R2 is supported on Windows Server 2008R2, 2012 & 2012 R2.

    However I just realized that KB2681562  explicitly states that SQL Server 2012 is supported on Windows Server 2016 as long as one is running at least SQL Server 2012 SP2.

    • Marked as answer by p_k_a Thursday, October 27, 2016 6:04 AM
    Wednesday, October 26, 2016 11:26 AM

All replies

  • Hi p_k_a,

    According to the following official document, SQL Server 2012 is not supported on Windows Server 2016. Please change your Operating System to Windows Server 2012 R2 or install SQL Server 2014/ SQL Server 2016 instead of SQL Server 2012 on Windows 2016. If you persist to install SQL Server 2012 on Windows Server 2016, you would need to use it at your own risk.

    https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396  

    Thanks,
    Lydia Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Wednesday, October 26, 2016 9:52 AM
    Moderator
  • I know about the document. However it seems to be dated. 

    I get it, the document doesn't mention Windows Server 2016 (most probably due to the fact that it was last refreshed before Windows Server 2016 was released.)

    Can you please point to an official document from Microsoft that states that SQL Server 2012 is not or will not be supported on Windows Server 2016?

    My understanding of the platform support policy was that SQL Server will generally be supported on at least 2 OS platform which are released after the SQL Server bits get released. For example SQL Server 2008 R2 is supported on Windows Server 2008R2, 2012 & 2012 R2.

    However I just realized that KB2681562  explicitly states that SQL Server 2012 is supported on Windows Server 2016 as long as one is running at least SQL Server 2012 SP2.

    • Marked as answer by p_k_a Thursday, October 27, 2016 6:04 AM
    Wednesday, October 26, 2016 11:26 AM
  • I know about the document. However it seems to be dated. 

    I get it, the document doesn't mention Windows Server 2016 (most probably due to the fact that it was last refreshed before Windows Server 2016 was released.)

    Can you please point to an official document from Microsoft that states that SQL Server 2012 is not or will not be supported on Windows Server 2016?

    However I just realized that KB2681562  explicitly states that SQL Server 2012 is supported on Windows Server 2016 as long as one is running at least SQL Server 2012 SP2.

    Hi p_k_a,

    I give you suggestions based on the article I post in my first reply and that time I haven't found the KB article you mentioned.

    I agree with you, the article is not updated in time. However, according to that updated KB2681562 article, it is supported to run SQL Server 2012 SP2 or later on Windows Server 2016, then you should be ok to use SQL Server 2012 SP3. And as stated in the KB article, please enable the .NET 3.5 Framework before you install SQL Server 2012 on Windows Server 2016.



    Thanks,
    Lydia Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, October 27, 2016 2:01 AM
    Moderator
  • Hello 

    Could be a little late for this post but is important to clarify the point.

    SQL server 2012 R2 can run over Windows Server 2016 if you deploy Service Pack 2

    Check this link for official information https://support.microsoft.com/en-us/help/2681562/using-sql-server-in-windows-8-and-later-versions-of-windows-operating

    Best Regards

    Stephan Torres

    Thursday, August 1, 2019 2:54 PM