November 14, 2013 at 7:15 am
Can anyone tell me what are the benefits of using a proxy account with SQL Agent to run SSIS Jobs?
I know that permissions need to be assigned to proxy/service account to access everything that SSIS Package is touching. But, can't the permissions be directly assigned to service account that SQL Agent is running under instead of creating a new account?
------------
🙂
November 15, 2013 at 4:43 am
Yes they can be setup for the account used as the service account, but the best practice is to limit the capabilities of a service account.
The use of a proxy can be more secure as even if a person manages to get the service account details to connect to the server the actions they can perfom is very limited.
MCITP SQL 2005, MCSA SQL 2012
November 15, 2013 at 7:22 am
Giving the service account permissions, would mean that all the jobs executed by that service accounts have permission to everything.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply