INF: How to Control the SQL Server Services on Windows 95/98

• Microsoft SQL Server version 7.0

SUMMARY

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

SQL Server 7.0 and MSDE 1.0 come with a utility called Scm.exe that you can use for this purpose. This utility is located in the Mssql7\Binn directory. 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 this utility, go to a command prompt and type scm and press ENTER.

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

scm -Action 6 -Service mssqlserver

scm -Action 7 -Service mssqlserver -SvcAccount LocalSystem

Additional query words: svc acct win 9x win95 win98 win9x

Keywords          : SSrvSQL_Admin 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbhowto kbinfo 

Last Reviewed: July 12, 1999