This project has moved and is read-only. For the latest updates, please go here.

Previous SQL Agent Job Proxy Accounts DBA Password Store Next

Change Proxy Account Password

It is important to synchronise the changing of a proxy account password in both Windows and SQL Server, otherwise SQL Server will use the old password value and the account may be locked out.

To change the password in SQL Server for a proxy, the details for the Credential are updated.

1) Start SQL Server Management Studio.
Connect to the instance using Object Explorer, and then navigate to Credentials. Right-click on the credential (e.g. ##xp_cmdshell_proxy_account##) and select Properties.
ProxyCredentialsProperties.png
2) Enter the new password and click OK. Save the new password to the DBA Password Store.
ProxyCredentialsPassword.png
SQL Server Management Studio can now be closed.

Copyright © 2012 - 2013 Edward Vassie. License and Acknowledgements
Previous SQL Agent Job Proxy Accounts Top DBA Password Store Next

Last edited May 23, 2013 at 4:16 PM by EdVassie, version 9