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
Description:
initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

Cause:

This error occurs due to the insufficient privilege of SQL Service Service Account in the Log directory : C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLog

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 FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAmaster.mdf;-eC:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLogERRORLOG;-lC:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATAmastlog.ldf

6. Browse the Log location “C:\Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLLog”.

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

Thanks,

Morgan
Software Developer