top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is a SQL Server Agent Proxy? Why are the proxies of any significance

+2 votes
What is a SQL Server Agent Proxy? Why are the proxies of any significance
posted Mar 17, 2014 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

SQL Server Jobs run in the security context of the account assigned to SQL Server Agent. We want to run a particular step of a job in a different security context. The answer is SQL Agent Proxy.

All the jobs run with the account assigned to SQL Agent service. What if we have to perform some task which requires some extra credentials or the other way around, then what should we do. The answer is SQL Server Agent Proxy. Proxy is about having additional security.

This is a SQL Server Object with already defined functionality. They are to provide limitation to the functionality provided to a proxy. A proxy can be defined with one or more sub-systems. The list of sub-systems is as follows:

ActiveX Script
Operating System
Replication Distributor
Replication Merge
Replication Queue Reader
Replication Snapshot
Replication Transaction-Log Reader
SQL Server Analysis Services Command
SQL Server Analysis Services Query
SQL Server Integration Services Package
Unassigned Proxy
To access the specified sub-system, the proxy has to use the security context of a Windows User.

answer Mar 26, 2014 by Amit Kumar Pandey