Export (0) Print
Expand All

AlwaysOn Client Connectivity (SQL Server)

This topic describes considerations for client connectivity to AlwaysOn Availability Groups, including prerequisites, restrictions, and recommendations for client configurations and settings.

In this Topic:

The section below provides information about AlwaysOn Availability Groups support for client connectivity.

Driver Support

The following table summarizes driver support for AlwaysOn Availability Groups:

Driver

Multi-Subnet Failover

Application Intent

Read-Only Routing

Multi-Subnet Failover: Faster Single Subnet Endpoint Failover

Multi-Subnet Failover: Named Instance Resolution For SQL Clustered Instances

SQL Native Client 11.0 ODBC

Yes

Yes

Yes

Yes

Yes

SQL Native Client 11.0 OLEDB

No

Yes

Yes

No

No

ADO.NET with .NET Framework 4.0 with connectivity patch*

Yes

Yes

Yes

Yes

Yes

ADO.NET with .NET Framework 3.5 SP1 with connectivity patch **

Yes

Yes

Yes

Yes

Yes

Microsoft JDBC driver 4.0 for SQL Server

Yes

Yes

Yes

Yes

Yes

* Download the connectivity patch for ADO .NET with .NET Framework 4.0: http://support.microsoft.com/kb/2600211.

** Download the connectivity patch for ADO.NET with .NET Framework 3.5 SP1: http://support.microsoft.com/kb/2654347.

Important note Important

To connect to an availability group listener, a client must use a TCP connection string.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft