Configuring SQL Mirror for Cyberstation

Issue

Configuring SQL Mirror for automatic Cyberstation fail-over when the primary SQL server fails.

Product Line

Andover Continuum

Environment

Local Area Network, Wide Area Network

Cause

How to configure SQL server mirror to allow Cyberstation to automatically, and seamlessly fail to the mirror.

Resolution

While a SQL server mirror can be configured for Cyberstation, there is nothing in Cyberstation that will allow a seamless fail-over. If the local SQL DBA has configured the mirror, Cyberstation will recognize the SQL server, but when the primary SQL server fails, Cyberstation will lose the SQL db connection. To re-connect, exit Cyberstation on all workstations and restart Cyberstation.