Online Documentation for SQL Manager for SQL server

Setting proxy properties

Use the Proxy tab of Proxy Editor to configure/view proxy properties. SQL Server Agent uses proxies to manage security contexts.

 

Name

Enter a name for the new proxy, or modify the name of the proxy being edited. Enable/disable the proxy using the Enabled option.

 

 

 

Credential

Each proxy corresponds to a security credential. Use the drop-down list to select a credential for the proxy.

 

Description

In this memo field you can supply an optional description for the proxy.

 

 

Each proxy can be associated with a set of subsystems and a set of logins.

 

Active to the following subsystems

Tick off the subsystem(s) to grant access to:

ActiveX script

Operating system

Replication Distributor

Replication Merge

Replication Snapshot

Replication Queue Reader

Replication Transaction-Log Reader

Analysis Services Command

Analysis Services Query

Integration Services Package

 

 

The Proxy principals group allows you to grant security principal access to the proxy.

 

Use the SQL Logins tab to grant access to SQL logins (with defined credentials).

To specify a login, select it in the drop-down list and click the Add to List button.

 

 

Use the Server Roles tab to grant access to fixed server roles.

To specify a server role, select it in the drop-down list and click the Add to List button.

 

 

 

Use the MSDB Roles tab to grant access to the database roles in the msdb database.

To specify a database role, select it in the drop-down list and click the Add to List button.

 

 

 

Right-click an item within the Granted SQL Logins / Server Roles / MSDB Database Roles list to call the context menu allowing you to delete a the selected principal and to refresh the list.