Service accounts

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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim P.Commented:
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 :)

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.