如果我重新启动 Windows，SQL Server 服务不再自动启动 [英] SQL Server service doesn't start anymore automatically if I make a Windows restart

问题描述

我有 Windows 10 build 1511，其中安装了 SQL Server 2014.

I have Windows 10 build 1511, where I have installed SQL Server 2014.

安装后一切正常.

我在 Windows 10 上多次关机，如果我打开电脑，一切正常.

I've made several times shutdown on Windows 10, and after if I turn on my PC everything is OK.

但是如果我重启系统，重启后，SQL Server服务仍然停止(启动类型是Automatic).我再次尝试重新启动和关闭，但该服务不再自动启动.

But if I restart the system, after the restart, the SQL Server service remains stopped (startup type is Automatic). I try another restart and shutdown, but the service doesn't start automatically anymore.

我手动启动了服务，服务启动后一切正常.如果我关闭一切，之后就可以了.但是如果我只是重新启动，我上面描述的问题就会再次出现.

I've started the service manually, and after the service is started and everything works ok. If I shut down everything, it is ok afterwards. But if I just restart, the problem that I've described above appears again.

我能做什么?

谢谢！

更新

问题好像已经报告给微软了:https://connect.microsoft.com/SQLServer/feedback/details/1873617/sql-server-not-coming-online-after-os-upgrade-to-windows-10-even-when-startup-type-is-automatic

It seems that the problem is already reported to Microsoft : https://connect.microsoft.com/SQLServer/feedback/details/1873617/sql-server-not-coming-online-after-os-upgrade-to-windows-10-even-when-startup-type-is-automatic

推荐答案

如果您启动了 SqlServer 服务的 services.msc 和 serach，在属性中，将启动设置为自动延迟而不是自动.

If you starts services.msc and serach for the SqlServer service, in properties, set the startup as automatic delay instead of automatic.

这篇关于如果我重新启动 Windows，SQL Server 服务不再自动启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！