How to stop sql server service using command (CMD)

Question

0.00/5 (No votes)

See more:

how to stop and start sql server instance using command line?
i`v trid following samples:
net stop MSSQLSERVER
and
net stop "SQL Server Agent (MSSQLSERVER)"
but after hitting this the cmd windows comes for a second and dissapears and the nothing happens to sql server named instance...

thanks...

Posted 22-Feb-13 3:13am

RedSakura

Updated 22-Feb-13 5:21am

v2

Add a Solution

Comments

Arun1_m1 22-Feb-13 9:29am

Are you trying to stop a named instance of SQL Server ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

willington.d · Answer 1 · 2013-02-22T03:28:00

Solution 1

Hi Sakura

Go to Command prompt
Run -> type cmd to to command prompt

To Start SQL Server
net start mssqlserver

To Stop SQL Server
net stop mssqlserver

Regards
Willington

Posted 22-Feb-13 3:28am

willington.d

willington.d · Answer 2 · 2013-02-22T03:28:00

Solution 2

Hi Sakura

Go to Command prompt
Run -> type cmd to to command prompt

To Start SQL Server
net start mssqlserver

To Stop SQL Server
net stop mssqlserver

Regards
Willington

Posted 22-Feb-13 3:28am

willington.d

Comments

Shubh Agrahari 22-Feb-13 9:33am

its not good to put solution more the once .....be care full for next time...

[no name] 22-Feb-13 9:35am

There is a bug that solutions are sometimes posted twice.

willington.d 22-Feb-13 9:40am

Its not my problem Shubh Agrahari. Please report this to Code Project.
Thanks for your kind advice.

Shubh Agrahari 22-Feb-13 9:43am

ya ok but there also a delete link that helps you to remove solution from your end ..

Shubh Agrahari · Answer 3 · 2013-02-22T03:39:00

Hi professional...

there is such a many commands for driving sql server throw command prompt ...

DESCRIPTION:
SC is a command line program used for communicating with the
NT Service Controller and services.
USAGE:
sc <server> [command] [service name] ...

The option <server> has the form "\\ServerName"
Further help on commands can be obtained by typing: "sc [command]"
Commands:
query-----------Queries the status for a service, or
enumerates the status for types of services.
queryex---------Queries the extended status for a service, or
enumerates the status for types of services.
start-----------Starts a service.
pause-----------Sends a PAUSE control request to a service.
interrogate-----Sends an INTERROGATE control request to a service.
continue--------Sends a CONTINUE control request to a service.
stop------------Sends a STOP request to a service.
config----------Changes the configuration of a service (persistant).
description-----Changes the description of a service.
failure---------Changes the actions taken by a service upon failure.
qc--------------Queries the configuration information for a service.
qdescription----Queries the description for a service.
qfailure--------Queries the actions taken by a service upon failure.
delete----------Deletes a service (from the registry).
create----------Creates a service. (adds it to the registry).
control---------Sends a control to a service.
sdshow----------Displays a service's security descriptor.
sdset-----------Sets a service's security descriptor.
GetDisplayName--Gets the DisplayName for a service.
GetKeyName------Gets the ServiceKeyName for a service.
EnumDepend------Enumerates Service Dependencies.

The following commands don't require a service name:
sc <server> <command> <option>
boot------------(ok | bad) Indicates whether the last boot should
be saved as the last-known-good boot configuration
Lock------------Locks the Service Database
QueryLock-------Queries the LockStatus for the SCManager Database
EXAMPLE:
sc start MyService

and for many more sql operation try this link..

http://msdn.microsoft.com/en-us/library/ms165702%28v=sql.105%29.aspx[^]

happy to help...