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.

Released for: Schneider Electric USA