How to correctly setup the connection string to availability group for legacy app

Question

Imagine you have the following scenario:

How the connection string should be?

I can think on two options:

Specify the availability group listener name as the Data Source.
Specify the primary replica as the Data Source and secondary replica as the Failover Partner

Which one should I use to get high availability and automatic failover? Other options?

Did you find a solution for this? I have the same issue right now. Would be much appreciated. — Justin, Apr 16 '18 at 15:04
you can do something like this https://www.dastagirhusain.com/2020/08/how-to-configure-your-availability-group-listener-in-as-net-project.html — Dastagir Husain Yasin, Aug 28 '20 at 18:43

score 6 · Answer 1 · edited Sep 22 '18 at 15:28

By the book is always to use the AG listener. I guess at the moment your connection string looks something like this:

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;
Initial Catalog=myDataBase;Integrated Security=True;

But if you successfully created an AG group, then change the connection string to use the AG listener, it would look something like this:

Server=tcp:MyAgListener,1433;Database=Db1;IntegratedSecurity=SSPI; 
MultiSubnetFailover=True

1 Answers1