Moving Vault problems

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

Moderator: SourceGear

Locked
Busboy
Posts: 55
Joined: Wed Mar 31, 2004 6:25 am

Moving Vault problems

Post by Busboy » Mon Oct 30, 2006 4:34 am

Hi,
We have moved Vault from one SQL server to a new one. This is causing us major problems.

We are able to login using Vault client, and view all repositories and files. When trying to check-out a file, we get: A database arror has occured (FailDBInsert). I need help to fix this problem.

This is what we have done so far:
1) Detached sgvault from old SQL server (servername=Terminal01)
2) Copied database to new SQL server (servername=SQL07)
3) Attached sgvault database to SQL07
4) Uninstalled vaultservice on Terminal01
5) Reinstalled vaulservice on Terminal01, using SQL07 as database

The sgvaultuser is DBO on sgvault database. I have verified that the sgvaultuser has read/write access to the database from the SQL Server enterprise manager.

How can I solve this problem?

Regards,
Kim
Attachments
sgvault.txt
Original filename: sgvault.log
(1.77 KiB) Downloaded 378 times
Vault.txt
Original filename: vault.config
(1.98 KiB) Downloaded 616 times
Web.txt
Original filename: web.config
(5.13 KiB) Downloaded 587 times

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

Post by jclausius » Mon Oct 30, 2006 8:59 am

Jeff Clausius
SourceGear

Busboy
Posts: 55
Joined: Wed Mar 31, 2004 6:25 am

Post by Busboy » Tue Oct 31, 2006 2:59 am

:D Thank you. This solved my problem.

Locked