START STOP RESTART SQL Server 2008 from command prompt
Posted on : 12-03-2012 | By : Devi Prasad | In : SQLServerPedia Syndication, Tools
1

Following commands can be used to start stop SQL Server service from command prompt.
Note: Run Command prompt as Administrator
Start SQL Server 2008
[sourcecode language=”plain”]net start mssqlserver[/sourcecode]
Stop SQL Server 2008
[sourcecode language=”plain”]net stop mssqlserver[/sourcecode]
Restart SQL Server 2008
[sourcecode language=”plain”]
net stop mssqlserver
net start mssqlserver
[/sourcecode]
Advanced Topics:
If you want to start/Stop a specific sql server instance replace mssqlserver with the name of the instance specific service[sourcecode language=”plain”]
net stop <<sqlserverservicename>>
net start <<sqlserverservicename>>
[/sourcecode]
For SQL Server Express the name would be MSSQL$SQLEXPRESS
[sourcecode language=”plain”]
net stop MSSQL$SQLEXPRESS
net start MSSQL$SQLEXPRESS
[/sourcecode]
How to find the service name?
1. Open Services.msc (open Run (windowskey+r) then type services.msc and click on ok)
2. In the read through the services(or click S to find all services starting with s)
3. Select a SQL Server service and doubleclick on it(or rightcick-properties)
4. In the popup you will have service name
5. Note down the service name (This is the name of the service – Display name is used for readability)
Following are the few of SQL Server related service names:
Display Name | Service Name |
---|---|
SQL Server (MSSQLSERVER) | MSSQLSERVER |
SQL Server Agent (MSSQLSERVER) | SQLSERVERAGENT |
SQL Server Analysis Services (MSSQLSERVER) | MSSQLServerOLAPService |
SQL Server Browser | SQLBrowser |
SQL Server Integration Services 10.0 | MsDtsServer100 |
SQL Server Reporting Services (MSSQLSERVER) | ReportServer |
SQL Server VSS Writer SQLWriter | SQLWriter |
Following are the few of SQL Server instance specific service names:
Display Name | Service Name |
---|---|
SQL Server (SQLEXPRESS | MSSQL$SQLEXPRESS |
SQL Server Agent (SQLEXPRESS) | SQLAgent$SQLEXPRESS |
Additional Notes:
If you try to start the SQL Server service which is already started you get the below error:
The requested service has already been started.
More help is available by typing NET HELPMSG 2182.
If you try to stop the SQL Server service which is not yet started you get the below error:
The SQL Server (MSSQLSERVER) service is not started.
More help is available by typing NET HELPMSG 3521.
If you try to start or stop SQL Server service when you do not have permissions you get the following error:
System error 5 has occurred.
Access is denied.
Resolutions:
1- Try to open command prompt as Administrator if it is not running in Admin mode.
2- Try to get Admin permissions on the Server.
If you try to start or stop SQL Server service when you do not have service installed you get the following error:
The service name is invalid.
More help is available by typing NET HELPMSG 2185.
Resolutions:
1. Check if SQL Server is installed on the server
2. Try to open command prompt as Administrator if it is not running in Admin mode.
3. Try to get Admin permissions on the Server.
2- Try to get Admin permissions on the Server.
Unable to start/stop any SQL Server sevice:
1. Check if the service name is correct.
You can use services.msc or use the command
[sourcecode language=”plain”]
sc query | findstr /I "MSSQL"
[/sourcecode]
2. Check if the Command prompt is in Admin mode
3. Check SQL Server error logs for additional details
Reference : Devi Prasad (sqlserverlearner.com)
Do you like my blog?
If you liked reading this blog, please help spread the word by sharing this blog with your friends.
Need Help On SQL Server?
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Tags: cannot start sql server browser 2008, how to start sql server 2005, how to start sql server 2008, how to start sql server 2012, how to start sql server agent, how to start sql server agent in sql server 2000, how to start sql server agent in sql server 2005, how to start sql server agent in sql server 2008, how to start sql server agent in sql server 2012, how to start sql server agent service, how to start sql server browser, how to start sql server browser service, how to start sql server service, how to start sql server service from command line, how to start sql server service in sql server 2005, how to start sql server service in sql server 2008, how to start sql server service in sql server 2012, how to stop sql server service, how to stop sql server service from command line, msdtsserver100 service, MSSQLServerOLAPService, net start MsDtsServer100, net start mssqlserver, net start mssqlserver /f /t3608, net start mssqlserver /m sqlcmd, net start mssqlserver access is denied, net start mssqlserver service name is invalid, net start MSSQLServerOLAPService, net start ReportServer, net start service sql, net start sql server agent, net start SQL Server Analysis Services, net start SQL Server Browser, net start SQL Server Integration Services 10.0, net start SQL Server Reporting Services (MSSQLSERVER), net start SQL Server VSS Writer SQLWriter, net start SQLBrowser, net start SQLSERVERAGENT, net start SQLWriter, net stop mssqlserver, net stop mssqlserver /f /t3608, net stop mssqlserver /m sqlcmd, net stop mssqlserver access is denied, net stop mssqlserver service name is invalid, net stop service sql, net stop sql server, net stop sql server instance, reportserver service, RESTART SQL Server 2008 from command prompt, sql server agent service, SQLBrowser, sqlbrowser sql server, sqlserveragent could not be started, sqlwriter service, sqlwriter service name, sqlwriter service sql server 2005, sqlwriter service sql server 2008, sqlwriter service sql server 2012, START MSSQLSERVER Service from command prompt, start reportserver service, start sql server 2005 service, START SQL Server 2008 from command prompt, start sql server 2008 service, start sql server 2012 service, start sql server agent 2008, start sql server agent command line, start sql server agent service, start sql server browser, start sql server browser 2005, start sql server browser 2008, start sql server browser 2012, start sql server service, start sql server service 2005, start sql server service 2008, start sql server service 2008 r2, start sql server service 2012, start sql server service command, start sql server service command prompt, start sql server service from command line, STOP MSSQLSERVER Service from command prompt, stop reportserver service, stop sql server 2005 service, STOP SQL Server 2008 from command prompt, stop sql server 2008 service, stop sql server 2012 service, stop sql server agent command line, stop sql server agent service, stop sql server service, stop sql server service 2005, stop sql server service 2008, stop sql server service 2008 r2, stop sql server service 2012, stop sql server service command, stop sql server service command prompt, stop sql server service from command line, unable to start sql server browser, unable to start sql server browser service