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

Article translations Article translations
Article ID: 196654 - View products that this article applies to.
This article was previously published under Q196654
Expand all | Collapse all

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

Properties

Article ID: 196654 - Last Review: June 11, 2003 - Revision: 3.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbhowto kbinfo KB196654

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com