{}

Our Brands

Schneider Electric USA Website

Welcome to our website.
How can we help you today?
How to Start and Stop SQL Server Service from a Command Prompt

Article available in these languages: Czech

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.

Command Prompt net stop mssql$ion


Command Prompt net start mssql$ion

Schneider Electric USA

How to Start and Stop SQL Server Service from a Command Prompt

Article available in these languages: Czech

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.

Command Prompt net stop mssql$ion 


Command Prompt net start mssql$ion 
 

Schneider Electric USA

Explore more
Product:
Explore more
Product:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Product:
Explore more
Product:
move-arrow-top
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.