EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Proxies


A Microsoft® SQL Server Agent proxy defines the security context for a job step. A proxy provides SQL Server Agent with access to the security credentials for a Microsoft Windows user. Each proxy can be associated with one or more subsystems. A job step that uses the proxy can access the specified subsystems by using the security context of the Windows user. Before SQL Server Agent runs a job step that uses a proxy, SQL Server Agent impersonates the credentials defined in the proxy, and then runs the job step by using that security context.

 

SQL Server proxies can be used to help database administrators ensure that each job step runs with the minimum permissions required to perform its task.

 

Before using SQL Server proxies, make sure that the SQL Server Agent service is running.

 

 

Proxy Editor allows you to define proxy properties. It opens automatically when you create a new proxy and is available on editing an existing one.

 

A SQL Server Agent proxy manages security for job steps that involve subsystems other than the Transact-SQL subsystem. Each proxy corresponds to a security credential. A proxy may have access to any number of subsystems.

 

To open a proxy in Proxy Editor, double-click it in the DB Explorer tree or in the Proxies manager. Alternatively, you can right-click the proxy alias and select the Edit Proxy context menu item.

 

 

To create, edit and drop proxies, you can also use the context menu and the Navigation bar of Proxies manager.

 

 


See also:

Proxies manager