v5.0.4: failed to reinstall Vault server using existing dbs

[kha]

I have existing vault dbs that I moved from different server.
I reinstalled the Vault server because after moving the dbs to new sql server, i couldn't login as admin.
So, I have the sgvault and sgmaster moved to new sql server fine.
Now, I uninstalled the vault server and then reinstalled the vault server (on same physical server), i got this error:

Looking for IIS Version
Configuring your new Vault Installation
Requesting the IIS Process User...Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for existing databases...Found.
Asking for database's fate...Keep existing.
Upgrading the existing source control database...
This may take a long time. Do NOT stop this process!
Found 'Auto Update Statistics' ON for database sgmaster -- setting it to OFF...OK
Found 'Auto Update Statistics' ON for database sgvault -- setting it to OFF...OK
Checking the installed database version...Upgrade failed.
Invalid object name 'tblschemaversions'.
Vault Setup is exiting due to a failure or cancellation. Error Code = 450

[Beth]

Was the original database from a Vault 5.0.4 server install or is this part of an upgrade at the same time?

Had you placed the database in place prior to installing Vault, or had you performed a restore after installing Vault?

Here's what I think you should do (assuming this isn't an upgrade):

• 1) Remove the current sgvault and sgmaster databases. You could do this by moving them or deleting them. Before deleting, make sure this isn't your only copy.
  
  2) Restore a fresh copy of the sgvault and sgmaster databases.
  
  3) Install Vault 5.0.4 server.

[kha]

This is not part of the upgrade. I already done with the upgrade when I was using the old sql server.

Now, i just simply moving from SQL server "A" to SQL server "B". Web server stays the same. Vault version stays the same.

The web server and sql server are not in the domain, they are physically 2 separate servers. When I install, which option (IIS process model) should i use? Machine, System, or Custom?

From my old printed out document for 3.5.x, Custom option doesn't ask you to enter in username and password to put in web.config for personate. 5.0.4 requires me to enter that when i chosed "CUSTOM" option.

The db instance that on my new SQL server is not a default instance. Is that matter?

[kha]

I think, I figured it out.

My sql server and vault server are on separate machine. They are not on the domain.
I am using sql 2005.
Not upgrading

• I deleted all the sgvault and sgmaster that I restored on the new SQL server earlier.
• Restored the their backups from old SQL server again on new SQL server
• Reinstalled the Vault server 5.0.4, choose Machine as IIS Process model
• When it asked for "authentication information used here is only used for the creation of the db", I choose option "SQL server authentication" and put in the 'sa' account and password. On the same screen, i entered "<db sername>\instance name>" for SQL server
• After it finished installation, i need to go to the web.config file to replace all the "\instance name" to "< ,port number of the instance> (example: server-sql, 1234)

Then I got it to work

[Beth]

Thanks for the update. I've never heard of needing to do that, but I'm happy to hear you are working fine. This information may be useful to users in the future.