I have three sql server 2005 servers, and I am about to switch them to from running their sql server service as a local user to running as a domain user. Should I use a unique domain user for each machine, or should I use just one domain user for all three?
I am inclined towards just creating one user for all three as they are going to have no real permissions on the rest of the network, their permissions will be administered locally on the machines they run the service upon. This will simplify my user config on my active directory, but are there any security concerns with doing this?
Thanks in advance,
-James
(this is related to my other question: What permissions are required for SQL Server to run as a (active directory) domain user)