How can stop and start the SQL services?

Also see Starting and Stopping Services on a Remote Computer

A. A. SQL has three services

The MSSQLServer service controls if the SQL Server is running and allowslogons/transactions. The SQLExecutive service is used for alerts, schedulingand other management tasks.

MSDTC is the Distributed Transaction Coordinator and is used for consistencybetween server transactions and is beyond the scope of the FAQ.

These services can both be stopped/started from the Services control panelapplet and you can also configure them to automatically start at bootup time byselecting one of them, clicking Startup and set to Automatic. Repeat for theother service.

To stop/start from the command line use

C:> net stop MSSQLServer
C:> net stop SQLExecutive
C:> net start MSSQLServer
C:> net start SQLExecutive

SQL actually comes with its own service manager (Start - Programs -Microsoft SQL Server 6.5 - SQL Service Manager) which enables you tostart/start/pause (pause is not available for SQLExecutive) services on variousSQL machines. It also shows the current state of the services in a trafficlight, ahhhh :-)

Click here to view image