Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Modify a Proxy (SQL Server Management Studio)

This topic describes how to modify a Microsoft SQL Server Agent proxy account. Only members of the sysadmin fixed server role can create, modify, or delete these proxy accounts.

NoteNote

After upgrading from SQL Server 2000, all user proxy accounts that existed before upgrading are changed to the temporary global proxy account UpgradedProxyAccount. The UpgradedProxyAccount is only granted access to those subsystems that were explicitly used, and does not have access to all subsystems after upgrading.

To modify a proxy account

  1. In Object Explorer, expand a server.

  2. Expand SQL Server Agent.

  3. Expand Proxies, expand the subsystem node for the proxy, right-click the proxy you wish to modify, and click Properties.

    On the General page, you can change the proxy account name, credential, or the subsystem it uses. On the Principals page, you can add or remove logins or roles to grant or remove access to the proxy account.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.