Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We just installed SQL Server on 1st node of windows cluster and it stop/start fine from configuration manager but from command line it is giving error and I checked that service account have all the rights on the folder, any idea how to fix the issue since we need to some tasks and I need to start SQL Server in single user mode from command line (registry entry looks fine):

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn>sqlservr.exe
2013-02-22 17:27:39.68 Server      Error: 17058, Severity: 16, State: 1.
2013-02-22 17:27:39.68 Server      initerrlog: Could not open error log file ''.
 Operating system error = 3(The system cannot find the path specified.).
2013-02-22 17:27:39.99 Server      Error: 17058, Severity: 16, State: 1.
2013-02-22 17:27:39.99 Server      initerrlog: Could not open error log file ''.
 Operating system error = 3(The system cannot find the path specified.).
2013-02-22 17:27:40.30 Server      Error: 17058, Severity: 16, State: 1.
2013-02-22 17:27:40.30 Server      initerrlog: Could not open error log file ''.
 Operating system error = 3(The system cannot find the path specified.).
2013-02-22 17:27:40.62 Server      Error: 17058, Severity: 16, State: 1.
2013-02-22 17:27:40.62 Server      initerrlog: Could not open error log file ''.
 Operating system error = 3(The system cannot find the path specified.).
2013-02-22 17:27:40.93 Server      Error: 17058, Severity: 16, State: 1.
2013-02-22 17:27:40.93 Server      initerrlog: Could not open error log file ''.
 Operating system error = 3(The system cannot find the path specified.).
2013-02-22 17:27:41.24 Server      Error: 17058, Severity: 16, State: 1.
2013-02-22 17:27:41.24 Server      initerrlog: Could not open error log file ''.
 Operating system error = 3(The system cannot find the path specified.).
share|improve this question
    
Have you verified the path for the error log? You can find it using the steps outlined here. –  Mike Fal Jan 13 at 19:24
1  
Is SQL Server clustered? If so, why are you attempting to start a clustered instance from the command line? And is this the currently active node? –  Aaron Bertrand Jan 13 at 20:51
1  
What switches are you passing? You'll need to pass in -c and probably -s. –  mrdenny Jan 14 at 6:51
    
Sounds like you are perhaps attempting to start the service on a non-active node. This would be one possible reason for this error message. –  Max Vernon Jan 15 at 1:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.