question

Derrick Smith avatar image
Derrick Smith asked

SQL 2008 R2 Error Log missing - instance won't start

Hi guys, I have a new SQL 2008 R2 cluster install that has been working fine for a few weeks. Today I tried to connect to it from a web server and got some login failure messages, so I went to check the error log to see why. I got an error when I tried to expand the error log folder from SSMS, so I decided to restart the instance (clustered on Server 2003 R2). The resource won't come back online...so the next step I normally take is to check the log file to see why....and there is the issue. There is no log file. Did the location change in 2008 R2 or something? Looking in the Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Log folder..usually I would expect to see errorlog, errorlog.1, etc.
sql-server-2008-r2clustererror
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Derrick Smith avatar image
Derrick Smith answered
So just for the record.. This happens when someone deletes your domain service account, thinking it's no longer required, without checking with the DBA first. The service can't auth with the login name so it can't even get to the step where it creates the log file. I will now get my sysops rifle that I save for occasions like these.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Don't forget to accept your answer - you get bonus points!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.