• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

MSSQL 2005 Will not start

I am unable to start MSSQL 2005 after a system reboot.  When I manually try to start the service through the SQL Server configuration Manager it fails with "The request failed or the service did no respond in a timely fashion".

I looked in c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG but it is not writing anything to the errorlog file.

What should I do next?  What is the best way to debug why it is not starting?
  • 3
2 Solutions
anything on the Event viewer ?
TedgClAuthor Commented:
No, nothing on the event viewer either.

We had issues this morning with our DNS server which was preventing all of our machines from authenticating with active directory.  The DNS information in Windows was updated with the new DNS servers and windows on this machine could then authenticate to login users.

Could it happen to have anything to do with this?  I have tried starting the service with "Log on as:" set to Local System but that did nothing.
TedgClAuthor Commented:
It was an authentication problem.  I went to the screen where you could specify "log on as:"  I reset the password in active directory of the user account I had used to setup the server.  I then typed in the new password for each of the SQL services.  It worked.

So, if you can't get SQL to start and it is writing no errors in the error log or event viewer it might be because it is not able to authenticate the service account to start the service
TedgClAuthor Commented:
I posted solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now