up vote 2 down vote favorite
share [g+] share [fb]

When I try to restart my SQL server, I get the following error:

enter image description here enter image description here

Why this error happens and how to solve this?

link|improve this question
2  
Did you check the eventlogs? – rene Jan 1 at 15:21
2  
upvotes are gained easily today – rene Jan 1 at 15:22
@rene, whatever do you mean? This looks like a really awesome programming question to me. – bzlm Jan 1 at 15:46
@bzlm Awesome it is then... – rene Jan 1 at 15:49
feedback

migrated from stackoverflow.com Jan 1 at 18:14

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 3 down vote accepted

When the Windows GUI starts a service, it displays a progress box for 60 seconds. After that, it will display the error "Service failed to resond in a timely fashion".

The message means no more than that the service didn't start in 60 seconds. This is not necessarily a problem: especially after a system halt, SQL Server can take a long time to start up, as it is rolling transactions backward and forward to get the databases in a consistent state.

Ignore the GUI error message, and check for details in the SQL Server error log.

link|improve this answer
If the service doesn't actually start, there won't be anything in the SQL Server error log. – bzlm Jan 1 at 15:47
@bzlm: Well if the excetable cannot be started at all, you'd get a different error message. – Andomar Jan 1 at 15:57
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.