Post reply

Restarting SQL Server Instance from SSMS Error

  • October 14, 2016 at 8:13 am

    #331351

    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?

  • October 14, 2016 at 10:12 am

    #1906621

    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....

  • October 16, 2016 at 1:43 am

    #1906774

    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?

  • October 17, 2016 at 6:54 am

    #1906841

    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!

  • October 17, 2016 at 11:23 pm

    #1907051

    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

  • October 18, 2016 at 10:30 am

    #1907209

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

    Sue

  • October 20, 2016 at 7:01 am

    #1907631

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

  • October 20, 2016 at 7:01 am

    #1907632

    How would I check this?

  • October 20, 2016 at 1:56 pm

    #1907779

    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

  • October 20, 2016 at 2:15 pm

    #1907786

    Are you using SSMS 2014 ?

  • October 20, 2016 at 4:44 pm

    #1907818

    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".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • October 21, 2016 at 7:11 am

    #1907947

    What am I looking for?

  • October 21, 2016 at 7:40 am

    #1907957

    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" 😉

  • October 21, 2016 at 7:52 am

    #1907962

    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

  • October 21, 2016 at 1:07 pm

    #1908080

    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 17 total)

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