I need to change the sgvaultuser and admin account password for my Vault
Can i please have a recommendation for best approach to accomplish this task?
v5.0.4: change sgvaultuser and admin password
Moderator: SourceGear
Re: v5.0.4: change sgvaultuser and admin password
You can change the Vault admin password from inside the Vault admin web page.
Changing the sgvaultuser password would be done in the SQL Server Management Studio, but it needs to be changed in the vaultservice web.config as well. The problem with changing it in the web.config is that it's encrypted, so you will need to change it from pwd=some_encrypted_password to password=plain_text_password.
To get the sgvaultuser password changed and encrypted takes an uninstall and reinstall of the server software. If you take this option, make sure you choose the option to keep your current databases and reuse them. You might also make sure you have current backups of your sgvault and sgmaster databases just in case you click a wrong button and drop them.
Changing the sgvaultuser password would be done in the SQL Server Management Studio, but it needs to be changed in the vaultservice web.config as well. The problem with changing it in the web.config is that it's encrypted, so you will need to change it from pwd=some_encrypted_password to password=plain_text_password.
To get the sgvaultuser password changed and encrypted takes an uninstall and reinstall of the server software. If you take this option, make sure you choose the option to keep your current databases and reuse them. You might also make sure you have current backups of your sgvault and sgmaster databases just in case you click a wrong button and drop them.
Beth Kieler
SourceGear Technical Support
SourceGear Technical Support