I am trying to set up the following.
I have configured the sql server side no problem. i am having issue getting the application that uses the database to connect to the mirrored server in the event of failure.
The application that utalises the database connects through the data sources (ODBC), System DSN, SQL driver. I see no option in the configuration for the addition of a 2nd IP. Many of the technical references i have read refer to the data source
connection string, i cannot find this in the registry however. Please help!
I am used to a 3rd party mirroring software where you connect to a logical IP address which then routes through to whichever database is running.
View Complete Post