Hello all. Recently I had need to change the password on the 'sgvaultuser' account on my sql server. I have since then realized that this would tend to make it very difficult for the admin tool to connect to the vault database to verify your username/password since the password in it's connection string would have to be updated as well. On the other hand, it seems silly to believe that there is one standard sgvaultuser password for everyone's installation, therefore I have to believe there's a config file somewhere that tells the vault server what username/password to use when connecting to the database. Any help locating where I would change it would be appreciated.
Scott (mayfield@magicworld.com)
Vault SQL User, Changing Password?
Moderator: SourceGear
Scott:
If you change the sgvaultuser's password, the connect string within web.config must change as well.
The easiest way to change the web.config connect string encrypted password is to uninstall / reinstall the server making sure to keep the database during both phases.
However, if you do not mind plain text passwords, you can use PASSWORD in the connect string.
Plain text passwords were covered in semi-related post - SQL Authentication broken after Database Move
If you change the sgvaultuser's password, the connect string within web.config must change as well.
The easiest way to change the web.config connect string encrypted password is to uninstall / reinstall the server making sure to keep the database during both phases.
However, if you do not mind plain text passwords, you can use PASSWORD in the connect string.
Plain text passwords were covered in semi-related post - SQL Authentication broken after Database Move
Jeff Clausius
SourceGear
SourceGear