24
2013
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
http://technet.microsoft.com/en-us/library/ms189064(v=sql.105).aspx
a) How to: Create a Credential (SQL Server Management Studio)
http://technet.microsoft.com/en-us/library/ms190703(v=sql.105).aspx
b). How to: Modify a Proxy (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms187890(v=sql.100).aspx
2. How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)
http://technet.microsoft.com/en-us/library/ms187901(v=sql.105).aspx
3. Configure a User to Create and Manage SQL Server Agent Jobs
http://technet.microsoft.com/en-us/library/ms187901.aspx
4. Implementing SQL Server Agent Security
http://msdn.microsoft.com/en-us/library/ms190926(v=sql.105).aspx
5. SQL Server Agent Fixed Database Roles
http://msdn.microsoft.com/en-us/library/ms188283(v=sql.105).aspx
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:
http://technet.microsoft.com/en-us/library/ms181362(v=sql.105).aspx
Other useful References:
SSIS and SQL Server Agent:
http://bi-polar23.blogspot.ca/2007/12/ssis-and-sql-server-agent.html
Details about Job creation with multiple options:
http://allcomputers.us/windows_server/sql-server-2008—sql-server-agent-(part-2)—jobs—proxies.aspx

Leave a comment
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 31 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5