SQL Server service not running

However, very next day today, when I went to office and turned on the machine, it did not start SQL Server. I was bit confused and very quickly checked SQL Server Services. I noticed that services were OFF. I tried to turn on the services but it keep on giving me following error.

The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details.

asked Mar 31 '12 at 03:01 PM in Default

tanzi
-3 ● 2 ● 2 ● 4

(comments are locked)

2 answers:

We need to see what is in the event log, it could be something related to privileges or could be a missing drive that contains the location of master, model, tempdb, etc.

answered Mar 31 '12 at 03:32 PM

Tim
31.5k ● 20 ● 31 ● 116

I've seen this tied in to changed privileges before, though as you say its not the only possibility and the log would help.

Apr 03 '12 at 05:19 PM TimothyAWiseman

(comments are locked)

I've had similar problems, usually when i change service accounts.

Noticed that I get different behavior if I try to start the SQL service via Control Panel - Services and not via the Configuration Manager. Configuration manager fails to start the service with error message, but Services manages to start the service.

Not sure if above is related to some kind of bug, haven't looked in to it since I always get it working.

If you don't get a clue in the logs, try to change the service account to localsystem in configuration manager and start the service in configuration manager and if it doesn't work try the services console and then change it back to your proper service account.

answered Apr 03 '12 at 02:26 PM