May 26, 2014 at 5:47 am
GilaMonster (5/17/2014)
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
See the section on 'can't create the error log.'
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
May 26, 2014 at 8:25 am
Ratheesh.K.Nair (5/26/2014)
Thanks Beatrix,I got the below messages.
C:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Binn>sqlservr.exe -m -
sR8
2014-05-26 16:14:33.41 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.41 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:33.71 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.71 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.01 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.01 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.31 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.31 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.62 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.62 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.92 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.92 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.22 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.22 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.52 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.52 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.82 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.82 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:36.12 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:36.12 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
Check the startup paramters for the sql server service via sql server config manager or via the registry.
The hive location is
HKEY_Local_Machine\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.instancename\MSSQLServer\Parameters
The key to check is
SQLArg1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2014 at 6:44 am
Thanks Gail and Perry.
The location exists and have access. I have given everyone full access to the location but still gets the same error.
May 30, 2014 at 7:01 am
The location does not exist. If it did, you wouldn't be getting this error:
The system cannot find the path specified.
You need to figure out where SQL is trying to create the error log (the registry key Perry mentioned should be it) and create the path SQL is expecting.
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
May 30, 2014 at 12:53 pm
Ratheesh.K.Nair (5/30/2014)
I have given everyone full access to the location but still gets the same error.
If inheritance is turned off you could see this issue. Open the security properties and under advanced options select the checkbox to force propogation to child objects then click apply.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2014 at 7:37 pm
GilaMonster (5/30/2014)
The location does not exist. If it did, you wouldn't be getting this error:The system cannot find the path specified.
You need to figure out where SQL is trying to create the error log (the registry key Perry mentioned should be it) and create the path SQL is expecting.
Thanks Gail,
The path mentioned in Registry is '-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Log\ERRORLOG' which does exists and have given full permission to everyone
May 30, 2014 at 7:40 pm
Perry Whittle (5/30/2014)
Ratheesh.K.Nair (5/30/2014)
I have given everyone full access to the location but still gets the same error.If inheritance is turned off you could see this issue. Open the security properties and under advanced options select the checkbox to force propogation to child objects then click apply.
I tried giving inheritance and it gave error on some trace files as the security policy cant be applied. Tried after this and got the same error.
May 30, 2014 at 10:39 pm
Ratheesh.K.Nair (5/30/2014)
Perry Whittle (5/30/2014)
Ratheesh.K.Nair (5/30/2014)
I have given everyone full access to the location but still gets the same error.If inheritance is turned off you could see this issue. Open the security properties and under advanced options select the checkbox to force propogation to child objects then click apply.
I tried giving inheritance and it gave error on some trace files as the security policy cant be applied. Tried after this and got the same error.
What was the error message??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2014 at 10:44 pm
Thanks Perry,
Its the same error message.
C:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Binn>sqlservr.exe -m -
sR8
2014-05-31 07:09:20.66 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:20.66 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:20.96 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:20.96 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:21.26 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:21.26 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:21.57 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:21.57 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:21.87 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:21.87 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:22.17 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:22.17 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:22.47 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:22.47 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:22.77 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:22.77 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:23.07 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:23.07 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-31 07:09:23.37 Server Error: 17058, Severity: 16, State: 1.
2014-05-31 07:09:23.37 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
June 6, 2014 at 4:00 am
Any help on this??
June 6, 2014 at 5:02 am
post screenshot of the following registry location
HKEY_LOCAL_MACHINE\SOFWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.R8\MSSQLServer\Parameters
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 16 through 25 (of 25 total)
You must be logged in to reply to this topic. Login to reply