Archive for September 1, 2015
Timeout with Multi-subnet Listener
September 1, 2015
Leave a comment
Time-out error and you cannot connect to a SQL Server 2012 AlwaysOn availability group listener in a multi-subnet environment
Once you are done with AG Creation and Listener configuration , change the RegisterAllProvidersIP value from 1 to 0.
PS C:\Users> Get-ClusterResource AG_ListenerName| Get-ClusterParameter RegisterAllProvidersIP
Change to 0
PS C:\Users> Get-ClusterResource AG_ListenerName | Set-ClusterParameter RegisterAllProvidersIP 0
Categories: Windows Cluster