Welcome to Lesson 3 of the SQL Server 2000 Tutorial. In this lesson we will cover Starting/Stopping SQL Server. I hope you enjoy the lesson.

Starting/Stopping SQL Server

Starting And Stopping SQL Server

You can start/stop SQL Server 2000 manually using the following methods.
 

1) Using SQL Server Service Manager: Click on the start/continue button.  You can also start SQL Server Agent, DTC (Distributed Transaction Coordinator, and Microsoft Search by using the services dropdown.

2) Using SQL Server Enterprise Manager: Right click on the stopped server and select start.

 

3) Using Services application in Control Panel: Right click the MSSQLSERVER service and select start.

 

4) Using the Command Prompt: At the command prompt type 'net start mssqlserver' and press enter.