Search FAQs
How to Start and Stop SQL Server Service from a Command Prompt
Product Line
Microsoft SQL Server
Environment
Command Prompt (DOS Window)
Resolution
Commands are as follows:
STOP:
default instance: net stop mssqlserver
named instance: net stop mssql$instance_name
example: net stop mssql$ion
START:
default instance: net start mssqlserver
named instance: net start mssql$instance_name
example: net start mssql$ion
1. Open a Command Prompt with administrative rights (run as administrator).
2. Type the required command.
3. Type 'Y' to proceed and press 'Enter' key.
NOTE: For the stop command, there will be a message that dependent services will stop as well. This includes SQL Server Agent and ION (In case PME is installed on the same server as SQL Server) services.
Microsoft SQL Server
Environment
Command Prompt (DOS Window)
Resolution
Commands are as follows:
STOP:
default instance: net stop mssqlserver
named instance: net stop mssql$instance_name
example: net stop mssql$ion
START:
default instance: net start mssqlserver
named instance: net start mssql$instance_name
example: net start mssql$ion
1. Open a Command Prompt with administrative rights (run as administrator).
2. Type the required command.
3. Type 'Y' to proceed and press 'Enter' key.
NOTE: For the stop command, there will be a message that dependent services will stop as well. This includes SQL Server Agent and ION (In case PME is installed on the same server as SQL Server) services.