Microsoft SQL Server 2005 Service fails to start

今天碰到一雷死人的事情，在Windows Server 2012 R2上安装SQL SERVER 2005标准版过程中一直遇到“The SQL Server service failed to start。 For more information......",最后下面两个组件无法安装成功。

 

后面查了一下，原来Microsoft SQL Server 2005在Windows Server 2012 R2上已经不支持了。一不小心踩了好大一个坑。官方解释如下：

Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10, Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 10, Windows 8.1, or Windows 8 detects an instance of SQL Server 2005.

 

参考资料：

https://support.microsoft.com/en-us/kb/2681562