Posted on 2005-04-22
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?