-
Open Server Manager.
-
Select Local Server and scroll down to Services.
-
Verify that the Status field is set to Running and the Startup Type field is set to Automatic, for SQL Server (MSSQLSERVER).
The MSSQL service is appended with the named instance you specified when you installed
Microsoft SQL Server. For example, if you installed SQL Server as an instance named
Instance1, the service displays as MSSQL$Instance1.
-
To change the Status or Startup Type fields, select Tools > Services in Server Manager.
-
Right-click the service name, and select Properties from the shortcut menu.
-
On the General tab, select Automatic from the Startup type list.
-
In the Service status section, select Start.
-
Select OK.