LLI Wiki — My Digital Knowledge Base

SQL Server: connection timeouts in a multi-subnet availability group

Avoid listener connection timeouts with MultiSubnetFailover.

In an Always On availability group spread over several subnets, the listener has one IP address per subnet. A client that tries these addresses one after the other can exceed its connection timeout after a failover.

The usual client-side fix is to add MultiSubnetFailover=True to the connection string, which makes the client try the listener IP addresses in parallel:

Server=tcp:AG1-listener,1433;Database=AppDb;MultiSubnetFailover=True;Integrated Security=SSPI

Notes

Mastodon LLIMastodon SocialFosstodon