SQL Server service doesn't start anymore automatically if I make a Windows restart

sql-server-2014
alex picture alex · Jan 14, 2016 · Viewed 30.2k times · Source

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

After installation everything is OK.

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

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.

What can I do ?

Thank you !

Update

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

Answer

Álvaro García picture Álvaro García · Jan 17, 2016

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

Related questions

SQL Server after update trigger

I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire table. CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE] …

Read More
Partition Function COUNT() OVER possible using DISTINCT

I'm trying to write the following in order to get a running total of distinct NumUsers, like so: NumUsers = COUNT(DISTINCT [UserAccountKey]) OVER (PARTITION BY [Mth]) Management studio doesn't seem too happy about this. The error disappears when I remove …

Read More
How do I create a local database inside of Microsoft SQL Server 2014?

Forgive me if this question was already asked before. I just installed Microsoft SQL Server Management Studio 2014. I want to create a database so I can start building some tables from scratch. All I am getting is the ability to …

Read More