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
- Choose Start > All Programs > Microsoft SQL Server 2012 R2 > Configuration Tools > SQL Server Configuration Manager.
The SQL Server Configuration Manager window is displayed.
- 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.