locked
SQL Server 2008 R2 on Windows Server 2012 R2 RRS feed

  • Question

  • Hi,

    I'm trying to understand why something happens so I will be able to explain it to my boss...

    When I try to install SQL Server 2008 R2 on my Windows Server 2012 R2 machine I encounter with the following problem:
    "Competability issue"
    and this is the warning that I see in the eventvwr:
    "The application (Microsoft SQL Server (2008 or 2008 R2), from vendor Microsoft) has the following problem:After SQl Server setup completes you will need to install Service Pack before running SQL Server on this version of Windows.
    for SQL Server 2008, you will need to install service pack 3 (SP3
    ) or later
    for SQL Server 2008 R2, you will need to install service pack 1 (SP1) or later

    I need to know why SQL Server 2008 R2 RTM doesn't work on Windows Server 2012 R2 any more?
    I know that it is not recommended to install 2008 R2 on 2012 R2 servers, and I know that SP and CU are importent but I need to answere on that particular issue...

    Thank you.

    • Moved by Tom Phillips Thursday, March 7, 2019 11:47 AM Installation question
    Thursday, March 7, 2019 11:09 AM

All replies

  • you have to use slipstream with sp2 .more information

    http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx


    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Thursday, March 7, 2019 5:37 PM
  • The message you get speaks for itself. SQL 2008 R2 RTM was never supported on Windows Server 2012 R2. The message is there to point out for you that you need to install SP1 to be supported.

    But of course, that message is entirely outdated. To be supported today, you need to install SP3. And then you will be supported until July. After July SQL 2008 R2 will not be supported at all, unless you have specifically bought extended support.

    So the answer to the question  I need to know why SQL Server 2008 R2 RTM doesn't work on Windows Server 2012 R2 any more? is that it never has, except maybe by chance.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Proposed as answer by Puzzle_Chen Friday, March 8, 2019 9:42 AM
    Thursday, March 7, 2019 10:13 PM
  • But in my case i know different...

    We had a machine with os 2012 r2 with sql server 2008 r2 rtm installed on it, and it worked just fine, until we updates the windows kbs and the sql stoped working...

    So it was supported, but what has changed?

    Monday, March 11, 2019 6:14 AM
  • But in my case i know different...

    We had a machine with os 2012 r2 with sql server 2008 r2 rtm installed on it, and it worked just fine, until we updates the windows kbs and the sql stoped working...

    So it was supported, but what has changed?


    What reference do you have that it was supported? The fact that it ran does not mean that it was supported. In fact, by the time Windows 2012 R2 was released, SQL 2008 R2 RTM was not supported on any platform - you were supposed to be on SP1 or more likely SP2 by then.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Monday, March 11, 2019 10:58 PM