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

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 CheckBox Enabled option.

 

Proxy Editor - Editing proxy definition

 

 

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:

CheckBox ActiveX script

CheckBox Operating system

CheckBox Replication Distributor

CheckBox Replication Merge

CheckBox Replication Snapshot

CheckBox Replication Queue Reader

CheckBox Replication Transaction-Log Reader

CheckBox Analysis Services Command

CheckBox Analysis Services Query

CheckBox 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.

 

Proxy Editor - Editing proxy definition - Server roles

 

 

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.

 

Proxy Editor - Editing proxy definition - MSDB roles

 

 

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.