September 27, 2008 at 3:29 am
We've got a SQL Server 2005 installation running on a Windows 2003 Server machine (standard edition, SP2). Yesterday the server needed to be rebooted, and following the reboot SQL Server could not be restarted - It appeared to time out while attempting to start up ("Windows could not start the SQL Server on local computer. For more information, review the system event log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17058"
The event log shows this whenever a restart is attempted:
"initerrlog: Could not open error log file 'Q:\Data\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(error not found)."
The file location above is valid, and can be accessed, but the ERRORLOG file was last written to 24 hours ago.
Disk space is fine on all disks on the server.
Does anyone have any ideas??
September 27, 2008 at 3:52 am
Does the SQL service account have rights to that directory?
Is anything else using that file (an antivirus, a text editor, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 27, 2008 at 5:12 am
I have now granted explicit permissions to that folder to the Network Service account (which SQL uses) and that appears to have resolved the problem - many thanks for your help Gail.
I have no idea why this has suddenly arisen however - something else for us to investigate!
All the best
Ian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply