I'm trying to set up Fortress 1.1.4.18402 to use mirrored database on MS SQL server. I have 3 databases (sgvault, sgmaster and sgdragnet) mirrored, so that if the principal server fails they all fail over to the mirror. However, when failover happens, Fortress does not accept logins saying there's no database connection. Does anyone have experience running Fortress on a mirrored database? Is such configuration supported?
Thanks.
Fortress\Vault and mirrored DB
Moderator: SourceGear
Re: Fortress\Vault and mirrored DB
Currently we don't support mirrored databases. It's ok to mirror just for an extra backup, but in order to use the copy, you would have to perform a separate install to that database. For those that want to use a mirror, I would recommend it only be one way, and then at that point that the first server actually goes down, then you can install Fortress to the copy.
Beth Kieler
SourceGear Technical Support
SourceGear Technical Support