Export (0) Print
Expand All
Expand Minimize
2 out of 2 rated this helpful - Rate this topic

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

When you delete a SQL Server Agent proxy account, make sure the proxy does not reference any active job steps. To check for any job steps that reference the proxy, right-click the proxy, click Properties, and click the References page. If you delete a proxy, you are given the option to reassign all job steps that use that proxy in the Delete Object dialog box.

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 delete a proxy account

  1. In Object Explorer, expand a server.

  2. Expand SQL Server Agent, and expand Proxies.

  3. Expand the subsystem of the proxy account you want to delete, right-click the proxy, and click Delete.

  4. In the General page of the Delete Object dialog, you can check Reassign to to reassign the job steps that reference this proxy to another.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.