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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 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 '14 at 20:51
1  
What switches are you passing? You'll need to pass in -c and probably -s. – mrdenny Jan 14 '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 '14 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.