Upgrade 3.5.2 to 4.0.5

[stefvanhooijdonk]

We have
SQL2005,Vault 3.5.2
We want to upgrade this to 4.0.5

we get the following error during the upgrade
OK
Configuring your new Vault Installation
Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an 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!
Checking the installed database version...OK
Creating SourceGear master database schema...OK
Grant database access to tamtam\paulb...OK
Upgrading SourceGear master database schema...OK
Upgrading SourceGear source control database schema...Database 'sgvault' is already open and can only have one user at a time.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

Why put the DB in "Single user" mode? and then make a second connection?

[Beth]

Usually, I'd see that error if a person made multiple attempts at upgrading. If one fails, then it stays in single-user mode.

A change that happened between Vault 3.x and 4.x is that there are now two databases, sgvault and sgmaster. Because of that large change, it's best to have a backup made before the upgrade so that returning to the single database is possible.

Was there multiple attempts made at upgrading?
If so, what happened after the first fail and what was the first error?

[stefvanhooijdonk]

It was already an upgraded DB. I know how to remove the single user setting

If i used a different user it does work. So it seemed to be security related

[jclausius]

When you connected to the database, did you use an account which has SQL Server Administrative privileges? If not, that might explain things, as a SQL Server Admin account is required to install the Vault server.