How to Control the SQL Server Services on Windows 95 or Windows 98 (196654)

SUMMARY

If you have SQL Server 7.0 or the Microsoft Data Engine (MSDE) 1.0 installed on a computer that is running Microsoft Windows 95 or Microsoft Windows 98, you may want to start and stop SQL Server or the MSDE services from a command prompt, or from a batch file (similar to using the net start and the net stop commands that are available on computers that are running Microsoft Windows NT).

SQL Server 7.0 and MSDE 1.0 come with a utility named Scm.exe that you can use for this purpose. This utility is located in the Mssql7\Binn folder. However, note that Scm.exe is not as comprehensive as the net commands, because it only mimics the functionality of the net commands for the services installed by SQL Server. Also, note that you cannot use Scm.exe to start the SQLServerAgent service on Windows 95 or Windows 98, although you can use the utility to start the MSSQLServer service.

MORE INFORMATION

For a complete list of the arguments used with the Scm.exe utility, open a command prompt, type scm, and then press ENTER.

Scm.exe Utility Examples

The following are examples that use the Scm.exe utility to start, stop, and modify the MSSQLServer Service:

Start the MSSQLServer Service

scm -Action 1 -Service mssqlserver

Stop the MSSQLServer Service

scm -Action 6 -Service mssqlserver

Modify the MSSQLServer Service Startup Account to the System Account

scm -Action 7 -Service mssqlserver -SvcAccount LocalSystem