SQL Alwayson multisubnet issue.

Hi,

We are facing timeout issue on SQL alwayzon with multisubnet configuration. 
When we tried with default connection time with 15s, they are facing connection timeout err on both the nodes.

Whereas when we changed default connection time to 30s, they were able to access without any issues.

Also when we connected to physical name and IP its connecting faster whereas when we tried to login to the AG group Name there was a delay.

And asper msdn article we tried fix the register value 0 but unable and getting failed.

Is there way to fix this issue if please share proper inputs. 

thanks 

June 20th, 2015 4:47pm

Hi

Have you tried specifying MultiSubnetFailover=True in your connection string?

Free Windows Admin Tool Kit Click here and download it now
June 20th, 2015 7:02pm

thanks jmcmullen, 

we resolved the issue with HostRecordTTL & RegisterAllProvidersIP . 

June 23rd, 2015 3:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics