Configuring SQL Server for Automatic Startup
After installation, to configure SQL Server as an automatically started service
-
From the Microsoft SQL Server 6.0 program group, start SQL Enterprise Manager.
-
From SQL Enterprise Manager's Server Manager window, open a server group and select a server.
-
From the Server menu, choose Configurations.
The Server Configuration dialog box appears.
-
From the Server Configuration dialog box, choose the Server Options tab.
-
Select the Auto Start Server At Boot Time Check box.
-
Choose the OK button.
To cancel automatic startup of SQL Server, perform the same procedure but clear the Auto Start Server At Boot Time Check box.
You can also use the Services application in the Windows NT Control Panel to configure SQL Server as an automatically started service. For information, see your manuals for Windows NT.