install help needed for VaultServer_3_5_1.msi

[d620]

Hello.
We had vault installed on our old pc machine which was our old webserver.

We have a new webserver (an actual server) and have migrated all the websites and databases including the valut db.

I am running the VaultServer_3_5_1.msi
and I hit keep existing db, and here is what it says:


OK
Configuring your new Vault Installation
Checking for IIS Version...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
Grant database access to NT AUTHORITY\NETWORK SERVICE...OK
Upgrading SourceGear Vault database schema...OK
Upgrading SourceGear Vault stored procedures...Invalid column name 'colistid'.
Invalid column name 'colistid'.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

Can you please help.

[Beth]

I'll need a bit more information first.
What is the SQL server version (include any service packs)?
What is the server OS?
Did you move the database via a backup and restore?
What is the size of the .mdf and .ldf?


Also, can you run the following SQL Query and post the results:

SELECT * FROM sgvault.dbo.tblschemaversions;

[d620]

SELECT * FROM sgvault.dbo.tblschemaversions;
= SG Vault 3.5.2.2

Moved db via right click attach and attached the mdf file.

What is the size of the .mdf and .ldf?
sgvault.mdf 171mb.
sgvault.mdf 3.71 gb

What is the server OS? Windows Server 2003 Version 5.2 R2 service pack 2

What is the SQL server version (include any service packs)?
Windows sql server 2005

Thanks.

[Beth]

Instead you should download either Vault 3.5.2 or you can upgrade to 3.5.3. You can download those .msi's on this page: Vault Previous Downloads