I am setting up a ODBC connection using SQL Server driver (not native client).
I have an option in this setup which is greyed out relating to mirroring which I would like enabled
Use The Failover SQL Server If The Primary SQL Server Is Not AvailableIf the primary server becomes unavailable, the driver attempts to reconnect to the primary SQL Server; failing that, it attempts to connect to the failover server. The failover server must be defined at the SQL Server.
I have made my mirror database the default. How can I define the failover server at SQL server?