CODEWITHSUNDEEP
c#sql-serverlegacysqlclientavailability-group
Jesús López
Jesús López

Reputation: 9241

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

Imagine you have the following scenario:

How the connection string should be?

I can think on two options:

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

Upvotes: 8

Views: 15203

Answers (2)

Pio
Pio

Reputation: 11

documentation: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-ver16 provides a detailed explanation on this.

Example connection string as recommended when we have multiple subnet connections to set MultiSubnetFailover=True.

Server=tcp:AGListener,1433;Database=AdventureWorks;Integrated Security=SSPI; MultiSubnetFailover=True

Upvotes: 1

Knotty
Knotty

Reputation: 91

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

Upvotes: 9

Related Questions