Friday, 30 May 2014

Event 17058 - initerrlog: Could not open error log file (SQL Server)

I got an error when I try to start the SQL Server service and the error message suggest me to analyze event log for further details, after I have analyzed found the following details in the event 17058.
Log Name:      Application
Source:        MSSQLSERVER
Event ID:      17058
Task Category: Server
Level:         Error
initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).


This error occurs due to the insufficient privilege of SQL Service Service Account in the Log directory : C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log

Troubleshooting and Fix:

1. Start SQL Server Configuration manager.
2. Click to select 'SQL Server Services' from the left menu options.
3. On the right panel, right click on 'SQL Server (MSSQLSERVER)' and click 'Properties'.
4. Click 'Advanced' tab.
5. Scroll down and copy the value stored in 'Startup Parameters' and paste it on textfile. It will be something like this :
-dC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
Event 17058 - initerrlog: Could not open error log file (SQL Server)

6. Browse the Log location "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log".
7. Right click on the folder "Log" and click Properties and then to visit to "Security" tab. Now, check SQL Server service account permission on this folder and give proper access to this folder.
8. Now, Restart the SQL Server service. if you face the same error again, try to change highly privileged service account like "Local System".

Software Developer


No comments:

Post a Comment