Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Jan 1 '12 at 18:14

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

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

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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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