Search FAQs
How to Start and Stop SQL Server Service from a Command Prompt
Issue
There may be instances where the only option to shut off the service is via a command prompt
Product Line
Microsoft SQL Server
Environment
Power Monitoring Expert Software with SQL Server using 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.