Created Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server Agent

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 8, 2012 at 11:33 am

  #259223

  I created a Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server Agent.

  I tested it with a Test Account and I was able to Select Run AS SQL Server Agent on the second attempt.

  I'm trying to do that no but when I click on the Drop down box SQL Server Agent is not there.

  I also created it for 3 external developers which I did not want to grant full admininstrative permission.

  I execute the EXEC dbo.sp_enum_login_for_proxy

  command and all of the users are displayed.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 8, 2012 at 1:50 pm

  #1498926

  I discovered that the Proxy that I created was unassigned.

  I did everything in T-SQL Code prior but I assigned the Proxy that I created to the SSIS Package Execution Proxie.

  I had a Domain Account created named SQLServerAgent.

  I had to add it to the Fixed Server Role sysadmin for the job to complete sucessfully.

  I'm not sure what I missed in the T-SQL Code?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/