Connecting to an AOAG / HADR database

  • Does anyone have a good link, or even a simple list of items, indicating best practices for apps connecting to your AOAG database? We're upgrading the dbs to 2012 and AOAG, but we need to make sure the apps have taken the proper steps to take advantage of the HADR benefits.

    I need to advise the devs how to prepare the conn strings, etc, to facilitate a successful failover.

    TIA!

    -SSS

  • The most important thing is the listener. You application's connection string will contain the listener.

    The listener will direct the application to the relevant node.

  • Pretty much eveerything you need is in here:

    http://technet.microsoft.com/en-us/library/hh213417.aspx

    The most important things are the listener and setting the correct application intent on your connection string. Also not all database connectivity drivers support the applicationintent setting so you need to be careful which ones you use.

    MCITP SQL 2005, MCSA SQL 2012

  • Thanks, guys!

    Anyone have a problem using the current DNS entry (pointed to the DB server), and repointing it to the Listener?

    -SSS

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply