I can see there have been many queries about this so I'm after a little confirmation.
I've gone through many articles about recommendations but was wondering if any one has had any real life experience.
What I have are two servers on a domain running SQL 2008 Standard. There will be replication, mirroring and jobs running server to server processes and jobs running SSIS packages that import data from a network share...
As far as the accounts go, I would use a Local System Account for the SSIS Service..that is pretty much standalone
I would then use a Domain account for The Agent and the agent account must be a sysadmin...as we are dealing with server to server processes.
The SQL Server account....can that be a local system account for the scenario above or does it need to be a domain account. In my experience I've always set it to a domain account.
Has anyone dealt with this ?
View Complete Post