Starting SQL Server Automatically

Starting SQL Server Automatically

SQL Server 2000

During installation, you can configure Microsoft® SQL Server™ to start automatically in the following ways:

  • You can configure an instance of SQL Server to start automatically each time you start the Microsoft Windows NT® 4.0 or Windows® 2000 operating system.

  • You can configure a server running Microsoft Windows 98 to start automatically. Select the Auto-start service when OS starts check box in SQL Server Service Manager. Windows 98 does not have a component that corresponds to Window NT 4.0 and Windows 2000 services. The SQL Server database engine and SQL Server Agent run as executable programs on Windows 98. These SQL Server components cannot be started as services automatically.

    Note  The SQL-DMO AutoStartServer property does not work with Windows 98.

  • You can also use the Services application in Control Panel.

After SQL Server is installed, you can enable or disable the server configuration using SQL Server Enterprise Manager. For more information, see the Windows NT 4.0 and Windows 2000 documentation.

To start an instance of SQL Server automatically

Enterprise Manager

SQL-DMO

To shut off automatic startup of SQL Server

Enterprise Manager

SQL-DMO

See Also

Using Startup Options

Show:
© 2016 Microsoft