August 30, 2016

How to fix SQL Server "MSSQLSERVER" service failed to start.

I installed SQL Server 2014 in windows 10, I having trouble starting SQL Server express, giving me the message "The SQL Server (MSSQLSERVER) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion."

This error happened because of the SQL Server unable to find your login ID credentials or you used the account which is not authorized to start the SQL services.



To fix this error you need to set authorized user to start the service. Now we use local account set to start the sql service.
  1. Administrative Tools > Services > SQL Server(MSSQLSERVER or your SQL server instance name)
  2. right click on MSSQLSERVER then select properties.
  3. move to Log On, then set the Log On option to the local system account.
  4. Click apply.
Also, set the start mode to automatically.
Then restart your computer.

No comments:

Post a Comment