fail to upgrade vault 2.0.6 to vault 3.5.1

[tentnology]

The "restore" function in the Vault Admin tool only restores a backup to the current SQL Server instance.

Since you are moving to a different SQL Server installation, the restore operation must be done outside of Vault, using SQL Server tools or commands.

You can download SQL Management Studio, a GUI management tool for SQL Server 2005 and 2005 Express (It replaces Enterprise Manager).

http://www.microsoft.com/downloads/deta ... oContainer

Directions for backing up with SQL Server Management Studio are here:
http://msdn2.microsoft.com/en-us/library/ms177429.aspx

Or you can use the sqlcmd utility. Details and examples here:

http://msdn2.microsoft.com/en-US/library/ms165702.aspx
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
http://msdn2.microsoft.com/en-us/library/ms162773.aspx

Hi: thanks for your previous reply about database issue. However, even I installed SQL Management Studio, I still had difficulities to transfer backup data from MSDE 2000 to SQL Server 2005 Express. Following the directions webpage, it seems that I only can restore the backup data into a new database within the same database engine. I can't restore data from MSDE 2000 database engine to SQL Server 2005 Express database
engine.

I decide to leave this issue for a while. Now I only use MSDE 2000 database engine and upgrade my vault 2.0.6 to vault 3.5.1. I uninstalled Vault 2.0.6 and kept my database unremoved. However it has error while I installed Vault 3.5.1. : after I chose to use current database and went over username and password for SQL server, the errors occurred as follows:
"
Vault Setup is existing due to a failure or cancellation, Error = -1280" I wonder if you can help me with this issue. Thanks.

[lbauer]

after I chose to use current database and went over username and password for SQL server

Is this in the SQL Server Setup portion of the installation? If you choose SQL Server authentication, then you need to enter the SA user and password here. The installer will use the SA credentials to modify the database.

The installer may be having problems connecting to your database in MSDE if:

-- MSDE is not set up for SQL Server authentication (by default it uses Windows authentication)

--you typed in a SQL Server username and password that does not have administrative rights in SQL Server.

Is MSDE on the same machine as the Vault Server? If so, have you tried installing using Windows Authentication in the SQL Server setup of the installer?

If you continue to experience difficulty, email the vault_install.log file to support@sourcegear.com ATTN Linda. The install log in in your user's temp directory, %temp%.