SQL Server 2000 Administration in 15 Minutes a Week: Advanced Installations - Page 4

May 17, 2002


Service Accounts

The last topic we are going to cover in this article is how to change the service accounts SQL Server 2000 uses. If you remember from my last article, during the installation of SQL Server we are prompted to choose what accounts we would like SQL Server to use. If you ever need to change the accounts used, the process is fairly simple.

To access the Services console in Windows 2000, open Control Panel and select Administrative Tools.



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.

Mike
maubert@databasejournal.com
www.2000trainers.com


» See All Articles by Columnist Michael Aubert









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers