Export (0) Print
Expand All
Expand Minimize

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

When you delete a Microsoft 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.

ms178090.note(en-US,SQL.90).gifNote:
After upgrading from SQL Server 2000 to SQL Server 2005, 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.

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft