Reconfiguring Vault after the Vault Server name changes

A collection of information about Vault, including solutions to common problems.

Moderator: SourceGear

Post Reply
lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Reconfiguring Vault after the Vault Server name changes

Post by lbauer » Thu Feb 17, 2005 11:00 am

This applies when Vault has been installed using the Machine\ASPNET account for the IIS Process model and Windows authentication for the SQL Server setup.

If the name of the machine hosting the Vault server changes, and you are running Vault as machine\ASPNET you will need to reinstall Vault. This is because the name of the ASPNET process running Vault is no longer valid. It is oldmachinename\ASPNET account, while it should now be newmachinename\ASPNET account.

First, delete the machine\ASPNET account from the sgvault database Users in MS SQL Server and from Security->Logins.

You can simply call

Code: Select all

sp_revokedbaccess N'Oldmachine\ASPNET' 
then:

Code: Select all

sp_revokelogin N'Oldmachine\ASPNET' 
to remove the old account.

Or, you can delete the account using Enterprise Manager or SQL Server Management Studio.

Then reinstall Vault.
Linda Bauer
SourceGear
Technical Support Manager

Post Reply