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?
TedgClAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

speshalystCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TedgClAuthor Commented:
I posted solution
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.