Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent Job - "Run As" drop down list is empty Expand / Collapse
Author
Message
Posted Friday, August 24, 2012 8:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 14, 2014 10:03 PM
Points: 3, Visits: 43
Why is the "Run As" drop down list is always empty when I try to set up a SQL Agent Job? I am trying to set up some SQL Agent Jobs to run using a proxy account. I am a member of the SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole. When I try to add a step to to the job, I select SQL Integration Services Package and the Run As drop down list is empty.

Anyone who is a sysadmin can view the proxy. Shouldn't I be able to use the proxy as a member of SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole? What am I missing here?

(Yes, the proxy account is active to the subsystem: SQL Integration Service Packages)

This is SQL Server 2008 R2
Post #1349715
Posted Monday, August 27, 2012 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 14, 2014 10:03 PM
Points: 3, Visits: 43
I found the answer to this. Any user who is not sysadmin has to have access to the proxy granted explicitly.

To grant access proxy accounts for non-sysadmins
1. In Object Explorer, expand a server.
2. Expand SQL Server Agent.
3. Expand Proxies, expand the subsystem node for the proxy, right-click the proxy you wish to modify, and click Properties.

On the General page, you can change the proxy account name, credential, or the subsystem it uses. On the Principals page, you can add or remove logins or roles to grant or remove access to the proxy account.

http://msdn.microsoft.com/en-us/library/ms187890(v=sql.100).aspx
Post #1350380
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse