Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Microsoft SQL Server service can be started by using Microsoft Windows net commands.
Note
SQL Server running on a cluster is best managed by using Cluster Administrator. For more information, see Using SQL Server Tools with Failover Clustering.
To start the default instance of SQL Server
From a command prompt, enter one of the following commands:
net start "SQL Server (MSSQLSERVER)"
-or-
net start MSSQLSERVER
To start a named instance of SQL Server
From a command prompt, enter one of the following commands. Replace <instancename> with the name of the instance you want to manage.
net start "SQL Server (instancename)"
-or-
net start **MSSQL$**instancename
To start SQL Server with startup options
Add startup options to the end of the net start "SQL Server (MSSQLSERVER)" statement, separated by a space. When started using net start, startup options use a slash (/) instead of a hyphen (-).
net start "SQL Server (MSSQLSERVER)" /f /m
-or-
net start MSSQLSERVER /f /m
Note
For more information about startup options, see Using the SQL Server Service Startup Options.
See Also
Tasks
How to: Start an Instance of SQL Server (SQL Server Configuration Manager)
How to: Start an Instance of SQL Server (SQL Server Management Studio)
How to: Start an Instance of SQL Server (sqlservr.exe)
How to: Pause and Resume an Instance of SQL Server (net Commands)
How to: Stop an Instance of SQL Server (net Commands)
How to: Change the Service Startup Account for SQL Server (SQL Server Configuration Manager)
Concepts
Stopping Services
Pausing and Resuming Services
Using the SQL Server Service Startup Options