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
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