My SQL Server instance's (SQL Server 2008 R2 Express) service has Startup Type = Automatic. The past couple of times I've restarted my computer the service has failed to start on its own, but it starts just fine when I manually start the service.
Event Viewer shows that the service fails to start because of a connection timeout. There are 2 entries regarding this timeout:
Entry 1
A timeout was reached (30000 milliseconds) while waiting for the SQL
Server (SQLEXPRESS) service to connect.Entry 2
The SQL Server (SQLEXPRESS) service failed to start due to the
following error: The service did not respond to the start or control
request in a timely fashion.
I checked the ERRORLOG files and there are no errors logged around the time of those Event Viewer entries.
Any ideas on the cause of this problem or how I can investigate further?
Best Answer
This issue happens because the SQL Server lost the logon id credentials or used an account without rights to start services.
For starting your services automatically, SQL Server needs an account with rights to start services during operating system start up.
To solve this issue you need to go Administrative Tools > Services > SQL Server(MSSQLSERVER or the name of your instances) > Right Click > Properties > Move to Log On > Set the Log On option using a Local System Account
If you have chosen this option, hit on Browse Button and find the Local Service Account or Network service Account there > Click in Apply.
Restart your computer and you will able to start your SQL Server.