February 6, 2009 at 9:22 am
Hi folks,
I'm not sure I'm in the right forum for this, but it seemed like the most suitable one...
I need to create a Windows user account which certain Sql Agent jobs can run under. I'm not too sure what sort of permissions I need to grant to this user. I intend to add this user to the SqlAgentOperatorRole in msdb, but I have no idea whether I'd need to add different Windows account permissions on top of this.
The Sql Agent jobs in question would be running SSIS packages for the most part.
These packages read from/write to files, and FTP files over to other boxes.
(Sql Server 2005, Windows Server 2003)
Any thoughts would be very much appreciated!
February 6, 2009 at 9:53 am
To reword my question (so that it hopefully makes more sense...):
Would a Windows account that's set up in msdb as SqlAgentOperator need explicit permissions to be able to perform all the tasks in the job the account would be running, or does adding the user to the SqlAgentOperator role take care of this behind the scenes?
Thanks again
February 6, 2009 at 10:46 am
The short answer is no, the long answer when you are running DTS/SSIS package as a job it executes in the context of the Agent with Admin permissions which could be proxy for an admin account. If your package is running from third part RDBMS the package owner who is the account you want to create must also be admin, this account cannot be run with a proxy however you can run the Agent with a proxy.
http://support.microsoft.com/kb/918760
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply