Resolving the SQL Server Error “The request failed or the service did not respond in a timely fashion”

When you are unable to log into your SQL Server, one recommended solution is to see if the required services are running. To do so, you can go to Start > Microsoft SQL Server 2005/2008 > Configuration Tools > SQL Server Configuration Manager.

image

Select the ‘SQL Server Services’ node and you can see the services that are running. If you observe in the screenshot shown below, the SQL Server service (MSSQLSERVER) is not running

image

When you right click and attempt to start the service, you may encounter an error that says “The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details”

image

One of the solutions to resolve this error is to see if the default port of SQL Server i.e: 1433 is not being used by a different service. Click on the ‘Protocols for MSSQLServer’ node

image

On investigating, I found that the VIA protocol was using up port 1433.

image

I disabled the protocol by right clicking on it and the problem got solved


About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

22 comments:

Anonymous said...

The proposed solution by Suprotim Agarwal re disabling VIA worked perfectly.

Anonymous said...

Thanx a lot, this a good solution

Anonymous said...

THANX A LOT SIR..really very helfull...i nearly struggled for 3 days regarding this problem.. and finally solved with ur solution.. thnaq thanq thanq...

Anonymous said...

I looked at my settings and it was already disabled but I still have the problem.

Anonymous said...

If VIA is already disabled, the workaround is found here
http://support.microsoft.com/kb/955494
Try and Start the service from Services snap-in console. If it doesn't start under the id specified, start under the local system account.

Anonymous said...

thanks, it work!

Anonymous said...

Very thnks for your solution....
No words to express this.......
Thanks a Lot.

Anonymous said...

Thank you very much yaar.Once again thanks for your post .It solved my problem .

Anonymous said...

Agarwal ji, you are star....I struggled 2hrs before this...;-)

Anonymous said...

Thank you much.. It helps me alot... :)

Regards
Minal

Spacemoses said...

I had this same problem. I determined that the problem was actually due to changing my Windows password that the SQL Server account used. Once I updated the password in the Configuration Manager for the service, I was able to start it just fine.

Anonymous said...

Tnx Very Useful Solution. Well it serve to me changeing the 1433 port, by 1434. Anyway tnx a lot.

Anonymous said...

Excellent

Anonymous said...

That Was Really Awesome....
I was Searching for Solutions Since Last 2 hrs..
Great Work....
Thanks .

Simon said...

Thanks a lot, it worked in my case!

asif said...

Thannnkkk Youuuuuu !!!!!!!!!!

Anonymous said...

Eres Grande Brotherr!!

Me Salvaste el Diaa!!!

Exitosss!!

y Thanks

DiegoS! said...

Velho Muito obrigado por seu post estava com esse problema e com sua ajuda foi resolvido obrigado mesmo

Anonymous said...

The sevice failed and or the did not respond in a timely fashion.
Consult the event log or other applicable error log for details.



not working

Zohair Ahmed said...


its Really work .VIA disable,Its very useful for me ,Working Perfectly,Thanks for sharing

Unknown said...

Thanx a lot, this a good solution

Unknown said...

Thanx a lot, this a good solution