eSight V300R010C00SPC200, 300, and 500 Single-Node System Software Installation Guide (Windows) 18

How Do I Restart the SQL Server Service

How Do I Restart the SQL Server Service

Question

How do I restart the SQL Server service?

If you fail to connect to the SQL Server database when the database is running properly, restart the SQL Server service.

Answer

  1. Choose Start > All Programs > Microsoft SQL Server 2012 R2 > Configuration Tools > SQL Server Configuration Manager.

    The SQL Server Configuration Manager window is displayed.

  2. Choose SQL Server Services > SQL Server (MSSQLSERVER), and right-click and choose Restart.

    Here, MSSQLSERVER indicates a SQL Server database instance name. It must be replaced by the actual instance name.