SQL Server 2014 - Restarting Service from SSMS

0

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?

sql-server
sql-server-2014
asked on Stack Overflow Oct 14, 2016 by user35762 • edited Oct 14, 2016 by TheGameiswar

1 Answer

0

If you are getting error from SSMS, try to restart the service from SQL Server configuration manager or from Services.msc.

From Services.msc

Run>Services.msc>Right Click on required SQL Server service>Stop>Start
answered on Stack Overflow Oct 14, 2016 by p2k

User contributions licensed under CC BY-SA 3.0