FailedDBReader

[Rich.Holmes]

I am getting this error:FailedDBReader when trying to open repositories after moving the DB to a new SQL Server. (Vault Version 2.0.0)

1.) Detached from old Sql Server
2.) Re-installed Vault Server
3.) Pointed to new SQL Server
4.) Detached New sgvault db
5.) Re-Attached old Sgvault db in it's place.

Now when I try to access the Repositories I get the error message above. If you click okay, you can see what is in the repository but you can not do any thing else.

Thanks
-Rich

[jeremy_sg]

Does your Vault server log give any clues as to the reason?

[Rich.Holmes]

Here is one of the entries:
Could not find stored procedure 'dbo.spgetlockedfilechangeswithsecurity'.
But after checking the SQL DB, the stored procedure is there

[jeremy_sg]

Are you using the same Vault server version for the old box and the new box? That is one of the stored procedures that changed with Vault version 2.0.1.

[Rich.Holmes]

Uhh. Then That might be the problem. To ensure that my Server files were good> I downloaded them again from the site (www.sourcegear.com) and now the server is the newest version while the db is still 2.0.0.
Should I reinstall 2.0.0?

[jeremy_sg]

Either you need to uninstall and reinstall 2.0.1 or install 2.0.0. If the database is present when 2.0.1 is installed, it will be upgraded.