November 21, 2013 at 2:20 pm
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
November 22, 2013 at 5:26 am
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.
November 22, 2013 at 6:00 am
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
November 22, 2013 at 9:09 am
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