Friday, March 06, 2015

SQL Server Always On Availability Groups and MultiSubnetFailover and OLEDB connections

Having problems with failover not working with SQL Server Always On Availability Groups?

Check whether you are using OLEDB Connections as OLEDB in SQL Native Client doesn't support MultiSubnetFailover keyword and ignores it even if available. Instead ADO.NET or ODBC need to be used.

No comments:

Post a Comment