Restarting SQL Server Instance from SSMS Error

  • Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by right-clicking and choosing restart, I get the following error:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Unable to restart service MSSQL$SQLSERVER on server SQLSERVER. (mscorlib)

    ------------------------------

    ADDITIONAL INFORMATION:

    The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    Any ideas?

  • Hi, to rule out SSMS being the issue, are you able to restart Sql Server via any other methods? For example - services.msc if not a clustered instance of course....

  • nickm_GR (10/14/2016)


    Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by right-clicking and choosing restart, I get the following error:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Unable to restart service MSSQL$SQLSERVER on server SQLSERVER. (mscorlib)

    ------------------------------

    ADDITIONAL INFORMATION:

    The object invoked has disconnected from its clients. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (mscorlib)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    Any ideas?

    Are you trying to start from server itself?

  • Hmm, that's interesting. I'm trying remotely. It looks like it works when I remote into the server and run the restart from SSMS on the server its self.

    What does that mean?

    Thanks!

  • Check what service account it is running under:

    Run services.msc > MSSQLSERVER Service. > Properties > Check service account

    NTAUTHORITY\SYSTEM

    NTAUTHORITY\LOCAL SERVICE

    NTAUTHORITY\NETWORK SERIVICE

    you may have it running under a different user account

  • It could also be due to not having Remote Registry access.

    Sue

  • It is running under a different account then the one I am logged in as, but both accounts have sys admin role membership.

  • How would I check this?

  • On the server, check Remote Registry service.

    You can check permissions via the registry - winreg key in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers

    The defaults I've seen have been Administrators Group and Backup Operators Group having access to the registry over the network. I believe there are also GPOs that can affect this.

    Sue

  • Are you using SSMS 2014 ?

  • When running remotely, you may have to start with the "Run as Administrator" for this to work.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • What am I looking for?

  • the issue occurs usually because you do not have local administrator permissions on the server which you'll need to stop and start services

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Microsoft SQL Server Management Studio 12.0.4100.1

    Microsoft Analysis Services Client Tools 12.0.4100.1

    Microsoft Data Access Components (MDAC) 6.3.9600.17415

    Microsoft MSXML 3.0 6.0

    Microsoft Internet Explorer 9.11.9600.18500

    Microsoft .NET Framework 4.0.30319.34209

    Operating System 6.3.9600

  • nickm_GR (10/21/2016)


    What am I looking for?

    winreg key, right click permissions. You can add a group or user, then select the group or user and select advanced to control the permissions.

    Another option would be to use SubinACL which still works on higher OS - I think it was originally in the Windows 2000 SDK. It's less convoluted than trying to manage the registry settings.

    You can download it from here:

    https://www.microsoft.com/en-us/download/details.aspx?id=23510

    And find directions on it's usage here:

    https://support.microsoft.com/en-us/kb/325349

    Sue

Viewing 15 posts - 1 through 15 (of 18 total)

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