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.
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.
