Online Documentation for SQL Manager for SQL server

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.

 

 

menuProxies

 

 

 

Creating Proxies

 

To create a new proxy:

  • right-click the Proxies node (within the Server Objects branch) or any object within this node in the DB Explorer tree and select the New Proxy item from the context menu;
  • define proxy properties using the appropriate tabs of Proxy Editor.

or

Hint: To create a new proxy, you can also select the Services | SQL Server Agent | Proxies main menu item to open the Proxies manager and select the Add Proxy... item from the context menu or on the Navigation bar.

 

To create a new proxy with the same properties as one of existing proxies has:

Alternatively, you can right-click a proxy in the DB Explorer tree and select the Duplicate Proxy <proxy_name>... context menu item.

 

Duplicate Object Wizard allows you to select the server to create a new proxy and to edit the result SQL statement for creating the proxy.

 

 

Editing Proxies

 

To edit an existing proxy:

  • select the proxy for editing in the DB Explorer tree (type the first letters of the proxy name for quick search);
  • right-click the object and select the Edit Proxy <proxy_name> context menu item, or simply double-click the proxy;
  • edit proxy properties using the appropriate tabs of Proxy Editor.

To change the name of a proxy:

  • select the proxy to rename in the DB Explorer tree;
  • right-click the proxy alias and select the Rename Proxy <proxy_name>... item from the context menu;
  • edit the proxy name using the Rename Object... dialog.

 

Dropping Proxies

 

To drop a proxy:

  • select the proxy to drop in the DB Explorer tree;
  • right-click the object and select the Drop Proxy <proxy_name>... context menu item;
  • confirm dropping in the dialog window.

 

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new proxy;

Ctrl+O to edit the selected proxy;

Ctrl+R to rename the proxy;

Shift+Del to drop the object.

 

 

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

 

 

See also:

Proxy Editor