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.
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 Studio12.0.4100.1
Microsoft Analysis Services Client Tools12.0.4100.1
Microsoft Data Access Components (MDAC)6.3.9600.17415
Microsoft MSXML3.0 6.0
Microsoft Internet Explorer9.11.9600.18500
Microsoft .NET Framework4.0.30319.34209
Operating System6.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 17 total)
You must be logged in to reply to this topic. Login to reply