Info – SQL Server Proxy accounts and job agent execution contexts

SQL Server proxies are used in cases where impersonation is required in complex and secured environments and more control is required while executing packages, jobs, PowerShell commands etc. below links and details are collected to give more info on this topic, it requires a good amount of reading and may take up to 2-3 hours to understand it completely, so be patient if you land on this page and go through all links and articles to understand it better.


Links provided are in context of SQL Server 2008 R2…


1. SQL Server agent proxies and how to create


a) How to: Create a Credential (SQL Server Management Studio)


b). How to: Modify a Proxy (SQL Server Management Studio)


2. How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)


3. Configure a User to Create and Manage SQL Server Agent Jobs


4. Implementing SQL Server Agent Security


5. SQL Server Agent Fixed Database Roles


6. The Run As drop-down list to select PROXY ACCOUNT in the General page does not apply to T-SQL scripts; it only applies to other step types that interact with the OS, such as PowerShell scripts, CmdExec, ActiveXScript, SSIS packages, etc. For T-SQL scripts you have to use EXECUTE AS to run it under different security context, more details are available on following links,


Ref. for this info:

Articles to read for EXECUTE AS information:



Other useful References:


SSIS and SQL Server Agent:


Details about Job creation with multiple options:—sql-server-agent-(part-2)—jobs—proxies.aspx

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 265 other subscribers

Translate this blog!



March 2021
« Nov    

View Post by Categories

%d bloggers like this: