Issue: (Failover had not occurred, commands executed without pause). Fixed. Key changes were RegisterAllProvidersIP=0, HostRecordTTL=300 (5 minutes instead of default 1200 (20 minutes)). If using .Net Framework 4.5+, recommend adding to client connection strings: MutiSubnet=True; Ref SqlClient support for HA and DR. Key steps were: Set RegisterAllProvidersIP=0 for the Cluster and LG. Set HostRecordTTL=300 (5 minutes instead of default… Continue reading SQL Server 2016 AlwaysOn in Windows Server 2012R2 WFC – MultiSubnet Listener returns wrong IP address after a FlushDNS – Error Connection Timeout!
You must be logged in to post a comment.