[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • 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?
0
TedgCl
Asked:
TedgCl
  • 3
2 Solutions
 
speshalystCommented:
anything on the Event viewer ?
0
 
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.
0
 
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
0
 
TedgClAuthor Commented:
I posted solution
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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