Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Service accounts

Posted on 2005-04-22
Medium Priority
Last Modified: 2012-05-05
I would like some advice on how to set up the accounts under which SQL Server 2000 and SS Agent run.  I am responsible for several servers.  I do not want either the SS service or the SSA service to run under the security context of the Local System Account.  All the servers are part of the same domain.

Should I establish domain accounts under which to run the services?  What about the same account for SS and for SS Agent?  Or to go to the next step, how about one account for all the servers and services?

As you may be able to infer from my questions, these are questions the network guy is asking me, and I just don't know the answers.

In your opinion, what's the best way to proceed?

Question by:guillotj
1 Comment
LVL 38

Accepted Solution

Jim P. earned 500 total points
ID: 13844437
We do it as one Domain User account for all services on all servers. The user account does not have elevated privleges on the network (no Admin, power user, etc) but is in the Local Administrators group on each server.

If the userid needs access to network recources it is added to the proper group and/or given rights to the resource. The userid has an e-mail account.

We change the password every sixty days -- but do not expire the password.  When you change the password, you need to stop all services using the account, change the password on the domain, then change the password on all the services, then fire them up.

That's my $0.02 :)

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question