Unable to restore backed up database.

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
Codeshed
Posts: 1
Joined: Tue Aug 11, 2009 5:04 pm

Unable to restore backed up database.

Post by Codeshed » Tue Aug 11, 2009 5:15 pm

I can back up databases fine, but when trying to restoring them i get the following error message..

Client = ‘FailDBConn’ – Vault

and from the log file:

System.Data.SqlClient.SqlException: Login failed for user 'SA'. The user is not associated with a trusted SQL Server connection.

This used to work fine, but has stopped in the past month or so.. I am not aware of anything changing on the server, except 'normal' updates.

Can you please advise.....

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Unable to restore backed up database.

Post by lbauer » Tue Aug 11, 2009 10:41 pm

What version of Vault are you using?

Is SQL Server authentication enabled on your SQL Server?

A quick fix would be to restore the backup using SQL Server tools until we can figure out the problem.
Linda Bauer
SourceGear
Technical Support Manager

Post Reply