Post reply

SHUTDOWN SQL command

  • February 3, 2011 at 12:25 pm

    #143236

    Hey everyone,

    I was doing some tests where I had to turn off SQL. Instead of going to the configuration manager and stop the service. I found the SHUTDOWN command and did what I wanted. But now how can I turn it on?

    I cannot connect to the server and through the configuration manager either. Any ideas?

    Thanks for your help and time

  • February 3, 2011 at 2:21 pm

    #1282162

    I've never used SHUTDOWN. Maybe start the services through Admin tools, or net start mssqlserver from a command prompt ?

  • February 3, 2011 at 3:25 pm

    #1282202

    Thanks for your reply,

    Me either, its the first and last time I use that command. I don't know why the SSL got corrupted (or missing).

    Anyways, I checked the Event Viewer and the service couldn't been loaded because it could not find the Cerfiticate for SSL

    In Event Viewer:

    Unable to load user-specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.

    ---

    TDSSNIClient initialization failed with error 0x80092004, status code 0x80.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    ---

    TDSSNIClient initialization failed with error 0x80092004, status code 0x1.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    ---

    SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    What I did was:

    change a registry value in:

    LM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL1\MSSQLServer\SuperSocketNetLib -> Certificate = an empty string.

    After that and changing some stuff in the protocol's properties (disabling force encryption) I was able to enable the sql service again.

    I almost uninstalled sql because it was pissing me off hehehe

  • February 3, 2011 at 4:05 pm

    #1282221

    SHUTDOWN is a T-SQL command, so you need a connection to execute it. It's the same, essentially, as clicking "Stop" in Services.

    If you can't connect to SQL, have you tried the Dedicated Admin Connection?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply