Use the following steps to configure Microsoft SQL Server Database Mirroring.
1.
Log in to the machine that hosts
2. Launch your ODBC or iODBC Data Sources Administrator.
3.
Locate your
4. Click the Configure button.
5. Scroll through the configuration screens until you find the Mirror Host drop-down menu.
6. Select the name of the Failover Server hosting the mirrored database.
1.
Log in to the machine that hosts
2.
Edit the odbc.ini file and location the
3. Set the connection option (-O) to -F <fail-over server name> to specify the Fail over server name for Database Mirroring.