Skip to content

modify-a-sql-server-agent-proxy.md

Latest commit

 

History

History
84 lines (56 loc) · 4.29 KB

modify-a-sql-server-agent-proxy.md

File metadata and controls

84 lines (56 loc) · 4.29 KB
title Modify a SQL Server Agent Proxy
ms.prod sql
ms.prod_service sql-tools
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
proxies [SQL Server Agent], modifying
modifying SQL Server Agent proxy
ms.assetid 6e1dfbaa-8089-4813-940c-d5a2e13d8552
author markingmyname
ms.author maghan
ms.manager jroth
ms.reviewer
ms.custom seo-lt-2019
ms.date 01/19/2017
monikerRange = azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts-allversions

Modify a SQL Server Agent Proxy

[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]

Important

On Azure SQL Database Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details.

This topic describes how to modify a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent proxy in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

Before You Begin

Limitations and Restrictions

  • [!INCLUDEssNoVersion] Agent proxies use credentials to store information about Windows user accounts. The user specified in the credential must have "Log on as a batch job" permission on the computer on which [!INCLUDEssNoVersion] is running.

  • [!INCLUDEssNoVersion] Agent checks subsystem access for a proxy and gives access to the proxy each time the job step runs. If the proxy no longer has access to the subsystem, the job step fails. Otherwise, [!INCLUDEssNoVersion] Agent impersonates the user that is specified in the proxy and runs the job step.

  • If the login for the user has access to the proxy, or the user belongs to any role with access to the proxy, the user can use the proxy in a job step.

Security

Permissions

Only members of the sysadmin fixed server role can create, modify, or delete proxy accounts.

Using SQL Server Management Studio

To modify a [!INCLUDEssNoVersion] Agent proxy

  1. In Object Explorer, click the plus sign to expand the server that contains the [!INCLUDEssNoVersion] Agent proxy account that you want to modify.

  2. Click the plus sign to expand SQL Server Agent.

  3. Click the plus sign to expand the Proxies folder.

  4. Click the plus sign to expand the subsystem node for the proxy (for example, ActiveX Script).

  5. Right-click the proxy account you want to modify and select Properties.

  6. In the proxy_nameProxy Account Properties dialog box, make changes to the proxy account as necessary. For more information on the options in this dialog box, see Create a SQL Server Agent Proxy.

  7. When finished, click OK.

Using Transact-SQL

To modify a [!INCLUDEssNoVersion] Agent proxy

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    -- Disables the proxy named 'Catalog application proxy'.  
USE msdb ;  
GO  
EXEC dbo.sp_update_proxy  
    @proxy_name = 'Catalog application proxy',  
    @enabled = 0;  
GO

For more information, see sp_update_proxy (Transact-SQL).