set up a sql server proxy account to run packages

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  April 25, 2011 at 6:01 pm

  #236229

  I'm using sql server 2008.

  The sql agent service is running under a windows account mydomain\mysqlsvc

  Now we would like to create a proxy account for

  non-admininstrator users to view and run sql agent jobs - specifically for those ssis packages.

  In SSMS, I first create a credential using the same account of sql agent service, in my case is mydomain\sysqlsvc.

  Then I go to sql server agent-Proxies- SSIS package execution- new proxy account, I name it Myproxyaccount, In the general screen I checked SQL server integration service pacakge, in the Principals screen I add SQLAGENTUSERROLE and SQLAGentOperatorRole, then click Ok.

  Then for permissions, since this package is to import from a file source to a database in this server, I also give the account mydomain\sysqlsvc as the dbowner of the database,

  also set up file level permission to this account.

  Is this all I need to do?

  Just confused about proxy account, cannot find a detailed instruction or example for how to set it up?

  Thanks

• Syed Jahanzaib Bin hassan

  SSChampion

  Points: 11410

  More actions

  April 26, 2011 at 3:38 am

  #1315730

  Just create a new login then give public role on msdb and give these 3 Roles to a newly added user

  1-SQLAgentOperatorRole

  2-SQLAgentReaderRole

  3-SQLAgentUserRole

  Regards,

  Syed Jahanzaib Bin Hassan

  MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog

  http://www.aureus-salah.com

  Regards,
  Syed Jahanzaib Bin Hassan
  BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog
  www.aureus-salah.com

• Sqlraider

  SSCertifiable

  Points: 5441

  More actions

  April 26, 2011 at 8:55 am

  #1315937

  Check out this link:

  http://msdn.microsoft.com/en-us/library/ms190698.aspx