Problem installing vault server on a different server

bclubb · Post by **bclubb** » Fri Jul 09, 2004 3:00 pm

We are rebuilding a webserver and trying to move the vaultservice to a different computer. When installing on the new server I get this error and the server is not installed.

Configuring your new Vault Installation
Checking for IIS Version...OK
Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an existing Vault database...Found.
Asking for database's fate...Keep existing.
Upgrading the existing Vault database...
This may take a long time. Do NOT stop this process!
Checking the installed database version...OK
Ensuring that sgvaultuser has access to the Vault database...The login 'sgvaultuser' already exists.
Vault Setup is exiting due to a failure or cancellation. Error Code = 0

bclubb · Post by **bclubb** » Fri Jul 09, 2004 3:17 pm

The Version Number is 2.0.3

mskrobul · Post by **mskrobul** » Fri Jul 09, 2004 4:03 pm

Are you moving your entire Vault installation (server and database) or just the server?

If you are moving the entire installation, verify you have performed the steps outlined in following KB article:

http://support.sourcegear.com/viewtopic.php?t=228

If that doesn't help, please send me your vault_install.log located in your temp directory (%temp%). It should contain some additional information about the error you are seeing.

bclubb · Post by **bclubb** » Mon Jul 12, 2004 1:48 pm

I am not moving the database, just the web server.

Vault log started at 12 Jul 2004 - 11.51.08

Custom action assembly location: C:\Inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
Custom Action version: 2.0.4

FileVersionInfo: File: C:\Inetpub\wwwroot\VaultService\bin\CustomActionExe.exe
InternalName: CustomActionExe.exe
OriginalFilename: CustomActionExe.exe
FileVersion: 2.0.4.2190
FileDescription:
Product:
ProductVersion: 2.0.4.2190
Debug: False
Patched: False
PreRelease: False
PrivateBuild: False
SpecialBuild: False
Language Language Neutral

The commandline args as passed in to us:

/TARGETDIR=C:\Inetpub\wwwroot\VaultService\
/TARGETDIR2=C:\Inetpub\wwwroot\VaultService\VaultShadowFolder\
/CUSTOMNAME=
/CUSTOMPW =
/PARAMS=
/DROPDB=
/UPGRADE=
/ADMINPW=
/SQLLOGIN=
/SQLPW=
/WINAUTH=
/SQLSERVER=
/IISPROCESS=0
End commandline args.

Validate the target dir for shadow folders
See if we need to do an upgrade or an install...Configuring your new Vault Installation
Entered CreateCryptoRegistryValues.
CreateCryptoRegistryValues completed successfully.
Entered GetIISProcessUser.
Checking for IIS Version... Registry return major version 6 of IIS.
OK
IIS Process Model user: NT AUTHORITY\NETWORK SERVICE
GetIISProcessUser completed successfully.
Requesting Vault Admin user password... Hashing the admin pw
OK
Connecting to the SQL Server...ConnectToDatabase() completed successfully.
OK
Verifying the SQL Server requirements... User is trying to install Vault to Microsoft SQL version 8.00.760
OK
Checking for an existing Vault database...Found.
Asking for database's fate...Keep existing.
Upgrading the existing Vault database...
This may take a long time. Do NOT stop this process!
Checking the installed database version...OK
Upgrading existing database user information with a new install.
UpgradeExistingDB (revoke) failed for sgvaultuser:
User or role 'sgvaultuser' does not exist in this database.. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at CustomActionExe.SetupForm.ExecuteSqlCommand(String cmd)
at CustomActionExe.SetupForm.UpgradeExistingDB(Boolean bOverwriteUserInfo)
UpgradeExistingDB (drop):
Login 'sgvaultuser' owns one or more database(s). Change the owner of the following database(s) before dropping login::System.Data.SqlClient.SqlException
Ensuring that sgvaultuser has access to the Vault database...Vault Setup is exiting due to a failure or cancellation. Error Code = 0
The login 'sgvaultuser' already exists.
Vault Setup is exiting due to a failure or cancellation. Error Code = 0
ExitCode on exit: 0

mskrobul · Post by **mskrobul** » Mon Jul 12, 2004 3:38 pm

It looks like the installer is having problems with the sgvaultuser, although these types of errors aren't usually fatal. I haven't been able to reproduce the bevhavior you are seeing.

Can you provide any further information about your setup? For example, what OS was the old server was on? What OS is the database on? What type of authenticaion did you use when you first created the database (windows or SQL)? It looks like you are using IIS 6.0 for the new install, so I assume you installing the new Server on Windows 2003? Any additional information you can privide to help us reproduce your problem would be helpful:-)

Is the Vault server still running on the old machine? If so, make sure IIS is stopped on that machine before you install the server on the other machine just encase it still has a hold on something in the database.

Try removing the sgvaultuser login from sql through enterprise manager before you try the server install and see if that helps. That login will get re-created when you install the server if you choose sql authentication for your authentication method.

bclubb · Post by **bclubb** » Mon Jul 12, 2004 8:18 pm

The situation is that we had a server that was running Windows 2003 from a windows 2000 upgrade. We wanted to do a fresh install so we tried to move the vault to another Windows 2003 Server where we received this error. I have since formatted the original Windows 2003 Server and am trying to reinstall the vault on this server. The SQL Database hasn't changed at all during this process. When I try to delete the sgvaultuser I get an error saying I can't delete the dbo user. In the sgvault database the sgvaultuser is listed as dbo. I also can't take it out of db_owner permission group.

mskrobul · Post by **mskrobul** » Tue Jul 13, 2004 8:19 am

When I try to delete the sgvaultuser I get an error saying I can't delete the dbo user. In the sgvault database the sgvaultuser is listed as dbo. I also can't take it out of db_owner permission group.

Are you connecting to sql as "sa"? If not, try connecting to SQL using the "sa" name and password and then try to remove the sgvaultuser. Also during the install, you should use the "sa" name and password for sql authentication.

bclubb · Post by **bclubb** » Tue Jul 13, 2004 8:23 am

The problem is fixed. I used sp_changedbowner to change the owner to another user and was able to do a new install. Thank you for all of the help.

spril · Post by **spril** » Thu Nov 11, 2004 9:29 am

Migrating Vault's service from one server to another didn't work for me either, until I deleted the sgvaultuser in Enterprise Manager, uninstalled Vault Server, and resintalled.

We upgraded from 2.02 to 2.06.

Thanks,

-Tom Jones
Apex Digital Systems
http://www.apexds.com

gmagana · Post by **gmagana** » Fri Nov 12, 2004 12:22 pm

Same here... I just tried it:

1) Restore a backup of a Vault server from another machine.

2) Uninstall Vault Server (choose to keep DB)

3) Install Vault (choose to use existing DB)

This is the ONLY way I have been able to move a Vault database from one machine to another.

Can Sourcegear perhaps give us a little program that does whatever the install does to get the existing DB working?

SourceGear Support