AAA is compatible with SQL 2012 or 2016 Always On Availabilty Group feature

Summary

AAA is compatible with SQL 2012/2016 Always On Availabilty Group feature

The SQL 2012 or 2016 Always On Availabilty Group feature is directly managed by SQL 201/2016 and AAA accesses the needed database through an ODBC link.

 

Two ODBC connection string keywords were added to support AlwaysOn Availability Groups in SQL Server Native Client:

  • ApplicationIntent,
  • MultiSubnetFailover.

 

The functionality of the ApplicationIntent and MultiSubnetFailover keywords will be exposed in the ODBC Data Source Administrator for DSNs that use the SQL Server Native Client driver, beginning in SQL Server 2012.

 

A SQL Server Native Client ODBC application can use one of three functions to make the connection:

Function

Description

SQLBrowseConnect

The list of servers returned by SQLBrowseConnect will not include VNNs. You will only see a list of servers without any indication if the server is a standalone server, or a primary or secondary server in a Windows Server Failover Clustering (WSFC) cluster that contains two or more SQL Server instances that have been enabled for AlwaysOn Availability Groups. If you connect to a server and get a failure, it may be because you have connected to a server, and the ApplicationIntent setting is not compatible with the server configuration.

Because SQLBrowseConnect does not recognize servers in a Windows Server Failover Clustering (WSFC) cluster that contains two or more SQL Server instances that have been enabled for AlwaysOn Availability Groups, SQLBrowseConnect ignores the MultiSubnetFailover connection string keyword.

SQLConnect

SQLConnect supports both ApplicationIntent and MultiSubnetFailover via a data source name (DSN) or connection properties

SQLDriverConnect

SQLDriverConnect supports ApplicationIntent and MultiSubnetFailover via connection string keywords, connection properties, or DSN.

 

  1. AAA used SQLDriverConnect function (http://msdn.microsoft.com/en-us/library/ms715433%28v=vs.85%29.aspx) to connect to the SQL database

  2. According to Microsoft documentation (http://msdn.microsoft.com/en-us/library/gg471494.aspx):
    SQLDriverConnect supports ApplicationIntent and MultiSubnetFailover via connection string keywords, connection properties, or DSN.

  3. AAA does not set by program ApplicationIntent and MultiSubnetFailover connection properties.

  4. Using connection string keyword (http://msdn.microsoft.com/en-us/library/ms130822.aspx) or DSN:
    ApplicationIntent and MultiSubnetFailover are taken into account according to Microsoft documentation.



---
Kb#2252

Article ID: 2252
Type: Article
Classification: - Installation Issue
Created: 20 Nov 2014 02:12:24
Modified: 9 Jul 2018 02:06:15
Item Types: 4TRESS AAA