Moving Vault problems

Busboy · 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

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

See if this link - XML stored procedures are not supported in fibers mode helps.

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

Thank you. This solved my problem.