Using Vault 2.0.6
Windows 2000 server - domain controller
Can Create a backup file, but when I try to restore from a file, it asks me for the sa password which I provide (even though I set it up for Windows Authentication).
This is the application error message:
Database Restore Failed - See server log file for details.
This is from the log file ....
Restore returned:Restore can not be completed while the VaultServer
is in Integrated Authority Mode. Restore can be completed using SQL
Server's Enterprise Manager
Anyone had the same problem??
Cannot restore
Moderator: SourceGear
Re: Cannot restore
The Vault Admin Tool's restore capability is very limited. The Admin Tool expects SQL Server to be running in mixed auth mode, and you must use the 'sa' account to restore the database.asimo4262 wrote:Using Vault 2.0.6
Windows 2000 server - domain controller
Can Create a backup file, but when I try to restore from a file, it asks me for the sa password which I provide (even though I set it up for Windows Authentication).
From the log message, it appears your SQL Server is running in Windows Auth Mode only. For these purposes, using a RESTORE DATABASE query or Enterprise manager to restore the backup will be the best way to restore the database.
Post back if you need more assistance restoring the backup through normal SQL Server means.
Jeff Clausius
SourceGear
SourceGear