Online Documentation for SQL Manager for SQL server
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.
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.
- select the Database | New Object... main menu item;
- select Proxy in the Create New Object dialog;
- define proxy properties using Proxy Editor.
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:
- select the Database | Duplicate Object... menu item;
- follow the instructions of Duplicate Object Wizard.
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.
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.
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.