Windows Server 2012 r2上的SQL server 2008 r2 rtm [英] SQL server 2008 r2 rtm on Windows server 2012 r2

问题描述

今天我在Windows Server 2012 R2上更新了我的KB，在该服务器上，有一个SQL Server 2008 R2实例。 < br style ="font-family：Gisha，'Segoe UI'，'Lucida Grande'，Verdana，Arial，Helvetica，sans-serif;颜色：＃333333; font-size：10.5px; text-align：right">
重新启动服务器后，我发现SQL Server服务无法启动，所以我尝试手动执行，其
因错误而失败（1053，关于超时）。

我搜索了事件查看器以查看是否存在与此问题相关的内容，但我没有发现
表明它发生的原因，直到我在管理中搜索部分，我看到一个类似这样的警告："此应用程序（Microsoft SQL Server（2008和2008 r2））有以下问题：不支持Microsoft SQL Server（2008和2008
R2）版本的windows"

此错误在重新启动该服务器后立即显示，因此我认为Microsoft已对新KB实施了一些
限制（据称与"服务终止"相关） 9月9日，但当我尝试在该实例上安装SP1时，它立即上升...



所以我想问一下你们是否知道在Windows Server 2012 R2上使用最新的KB结束SQL Server 2008服务的可能性是什么？为什么会发生？到我的SQL Server？

解决方案

其中一个Windows安全补丁可能禁用了TLS 1.0安全协议，这是旧版SQL所必需的要启动的服务器服务。

安装SQL Server 2008 R2 SP2后，这会使构建版本达到10.50.4344.0或10.50.4047.0（或更高版本），这是最早版本的支持TLS 1.1 / 1.2的SQL 2008 R2。

参考：

TLS 1.2支持Microsoft SQL Server

HTH，

Hi, 

Today I updated my KBs on Windows Server 2012 R2, and on that server, there is an instance of SQL Server 2008 R2.
After I restarted the server I saw that the SQL Server Service wouldn't turn on so I tried doing it manually, its failed with errors (1053, about timeout).
I've searched on the event viewer to see if there is something related to this issue, but I found nothing that indicates why it is happening, until I've searched in the administrative section and I saw a warning that goes something like this: "this application (Microsoft SQL Server (2008 and 2008 r2)) has the following problem: Microsoft SQL Server (2008 and 2008 R2) is not supported on this version of windows"
this error showed up right after the reboot of that server, so I assumed that Microsoft has implemented some restrictions on the new KBs (allegedly related to the "end of service" on 9 in July), but when I tried to install SP1 on that instance, it went up right away...

so I want to ask if something is known to you guys about the posibility of ending the service of SQL Server 2008 R2 RTM on Windows Server 2012 R2 with the latest KBs? and why is happened to my SQL Server?

解决方案

One of the Windows security patches probably disabled TLS 1.0 security protocol, which is required for older versions of SQL Server service to start.

Once you install SQL Server 2008 R2 SP2, this brings build version up to 10.50.4344.0 or 10.50.4047.0 (or higher), which are the earliest versions of SQL 2008 R2 that supports TLS 1.1/1.2.

Reference:
TLS 1.2 support for Microsoft SQL Server

HTH,

这篇关于Windows Server 2012 r2上的SQL server 2008 r2 rtm的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！