Upgrade 3.5.2 to 4.0.5

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
stefvanhooijdonk
Posts: 22
Joined: Thu Jan 19, 2006 10:05 am
Location: Tam Tam BV, The Netherlands
Contact:

Upgrade 3.5.2 to 4.0.5

Post by stefvanhooijdonk » Fri Oct 26, 2007 6:51 am

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?
Stef


Architect/LeadDev @ Tam Tam
visit us at http://www.tamtam.nl

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Post by Beth » Fri Oct 26, 2007 7:49 am

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
Posts: 22
Joined: Thu Jan 19, 2006 10:05 am
Location: Tam Tam BV, The Netherlands
Contact:

It was an upgraded DB

Post by stefvanhooijdonk » Fri Oct 26, 2007 9:15 am

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
Stef


Architect/LeadDev @ Tam Tam
visit us at http://www.tamtam.nl

jclausius
Posts: 3655
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Thu Nov 01, 2007 2:30 pm

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.
Jeff Clausius
SourceGear

Locked