Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to configure mirrored DB on ODBC for failover Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 12:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:32 AM
Points: 24, Visits: 211
Hello,
I am having a question on configuring mirror DB on ODBC. When a Principal DB goes down the mirror DB comes up & becomes the principal DB, this will be in the case of High safety with/without automatic failover.

However, I am intreseted to know, how can we make this work on ODBC. I have configured a SQL Server Native client & created the ODBC setup, mentioned the mirror instance name as well & using a SQL Authenticated login.

The moment i do a failover on the DB side, the connection on the application side breaks inspite of mentioning the mirror instance.

I am not able to understand how can i make this work so that when the DB is failed over, the application shouldn't break, just like clustering.

Thanks
Asir

Post #1420400
Posted Sunday, February 17, 2013 11:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:32 AM
Points: 24, Visits: 211
SQL Server Gurus any solution to mu question?
Post #1421039
Posted Wednesday, February 27, 2013 10:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 5:12 AM
Points: 159, Visits: 178
If you don't see the option for Failover in the ODBC driver you need to install a newer ODBC. If I remember right you need to have at least SQL server native client 10 to support failover. When you create the new data source, select the Native 10 (or higher) driver.

You have to select a default database (of course) and then can select a mirror server. (this is on the second page of creating a new DSN)
Post #1424646
Posted Wednesday, February 27, 2013 11:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 5:12 AM
Points: 159, Visits: 178
After re-reading your original post, it looks like you may be using the correct client (As you mention you have the mirror instance set)

As a troubleshooting test I would failover the server and see if you can create a connection to the mirror only - set it as the primary server, as if there were no mirroring.

What king of authenitcation are you using NT or SQL? SQL users have to have the same SID on the principal and the mirror (otherwise they will be a db orphan when flipped to the mirror)
Post #1424664
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse