SQL Server 2000 Administration in 15 Minutes a Week: Advanced Installations - Page 4
May 17, 2002
Click to Enlarge
Open Services to launch the Services console.
When you scroll down the list of services you should see MSSQLServer and SQLServerAgent if your SQL Server is installed as a Default Instance. If you have one or more Named Instances installed, the name of the services are MSSQL$InsName and SQLAgent$InsName (where InsName is the instance's name) respectively.
Once you have located the appropriate service, you can double click to view the properties for that service.
On the General tab you can stop, start, pause, and resume the service. Setting the Startup type allows you to specify if the service should start when Windows starts (Automatic), should only start if the service is required or if you start it by hand (Manual), or if the service should never run even if required (Disabled). You can also give this service a description -- handy if you have many named instances installed.
The last screen we are going to look at in the Services section is the Log On tab. From here you can select the account the Service will use. You can select to use the Local System account or you can use another account (ex: a Domain account). Clicking the Browse button lets you see a list of available users to select from.
That will finish it up for this week and will also complete our look at SQL Server 2000 Installation topics. Next week we will take a look at the Enterprise Manager. As always, if you have any technical questions please post them on the SQL message board.Please send any non-technical questions, comments, and feedback to my email. I hope you are finding this series to be a useful one, and I'm looking forward to your feedback.