How to: Start an Instance of SQL Server (SQL Server Management Studio)

Microsoft SQL Server can be stopped and started from SQL Server Management Studio.

To start an instance of SQL Server

1. In Registered Servers or Object Explorer, right-click the server instance you want to start, and then click Start.

   A green arrow on the icon next to the server name indicates that the server started successfully.

Note

SQL Server running on a cluster is best managed with Cluster Administrator. For more information, see Using SQL Server Tools with Failover Clustering.

See Also

Tasks

How to: Start an Instance of SQL Server (SQL Server Configuration Manager)
How to: Start an Instance of SQL Server (net Commands)
How to: Start an Instance of SQL Server (sqlservr.exe)
How to: Pause and Resume an Instance of SQL Server (SQL Server Management Studio)
How to: Stop an Instance of SQL Server (SQL Server Management Studio)
How to: Change the Service Startup Account for SQL Server (SQL Server Configuration Manager)
How to: Configure WMI to Show Server Status in SQL Server Tools

Concepts

Stopping Services
Using the SQL Server Service Startup Options

Help and Information

Getting SQL Server 2005 Assistance