How does one change the password for sgvaultuser?
Moderator: SourceGear
-
Jeremy Heiner
How does one change the password for sgvaultuser?
Our Vault connects to the DB using SQLServer authentication. I know how to change the password for the sgvaultuser login... But how do I get the change into web.config?
jeremy:
as you've already noticed, the password in web.config's connect string is encrypted.
if you change the sgvaultuser password, you will have to change the connect string to match.
here are some options you can use:
1) uninstall / reinstall the vault server. the vault server will correctly change your settings in vault.config. upon both runs, make sure NOT to drop the database.
2) i'm attaching to this message an officially UNsupported* tool to help encrypt passwords. it must be run on the machine where the vault server is installed. extract and run 'vaultenchelper e'. it should prompt you for your plain text password, and spit out what the encrypted text. replace the PWD entry with this info. * - i haven't fully tested this application in every scenario, so let me know if it fails. i'll try to help see what is up.
3) use a PLAIN TEXT password. the connect string supports plain text password information when used with the PASSWORD property. just change PWD = encrypted_pwd to PASSWORD = plaintext_pwd. in this scenario, please make sure you've looked security access down on web.config, because gaining unauthorized read access to this file may pose a big security risk.
as you've already noticed, the password in web.config's connect string is encrypted.
if you change the sgvaultuser password, you will have to change the connect string to match.
here are some options you can use:
1) uninstall / reinstall the vault server. the vault server will correctly change your settings in vault.config. upon both runs, make sure NOT to drop the database.
2) i'm attaching to this message an officially UNsupported* tool to help encrypt passwords. it must be run on the machine where the vault server is installed. extract and run 'vaultenchelper e'. it should prompt you for your plain text password, and spit out what the encrypted text. replace the PWD entry with this info. * - i haven't fully tested this application in every scenario, so let me know if it fails. i'll try to help see what is up.
3) use a PLAIN TEXT password. the connect string supports plain text password information when used with the PASSWORD property. just change PWD = encrypted_pwd to PASSWORD = plaintext_pwd. in this scenario, please make sure you've looked security access down on web.config, because gaining unauthorized read access to this file may pose a big security risk.
- Attachments
-
- vaultenchelper.zip
- vault encryption helper - can encrypt, decrypt and generate key information req'd for vault.
- (26.18 KiB) Downloaded 625 times
Jeff Clausius
SourceGear
SourceGear
-
Albert
Where is the PASSWORD Property ?
Where is the PASSWORD property located in ? in vault.config ? web.config ? How can I change it ?jclausius wrote:jeremy:
3) use a PLAIN TEXT password. the connect string supports plain text password information when used with the PASSWORD property. just change PWD = encrypted_pwd to PASSWORD = plaintext_pwd. in this scenario, please make sure you've looked security access down on web.config, because gaining unauthorized read access to this file may pose a big security risk.