locked
SQL 2008 R2 clustered instance does not start in single user mode RRS feed

  • Question

  • Hi

    I am testing the startup of a SQL 2008 R2 clustered instance (Windows 2008 R2) using single user mode but it fails with :

    Error: 17058, Severity: 16, State: 1.
    initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.)

    - I am running the following command from the default sql installation :

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL01\MSSQL\Binn>sqlservr.exe -c -m -s SQL01

    - The cluster service on the passive node has been shutdown.

    - The SQL Server and SQL Agent services have been set to offline in Failover Cluster Manager.

    Any assistance greatly appreciated.

    Regards,

    PK

     

     

    Tuesday, August 31, 2010 4:57 AM

Answers

  • This issue occurs because the command prompt which i ran the sqlservr.exe command didn't have the elavated "administrator" priviledges.

    Use the "Run as Administrator" to launch the Command Prompt!

     

    • Marked as answer by Newbie2000l Tuesday, August 31, 2010 5:42 AM
    Tuesday, August 31, 2010 5:36 AM