Return
-
Title
What are the details of Active Roles support for SQL Clustering? -
Description
What are the details of Active Roles support for SQL Clustering? -
Resolution
Active Roles 7.x.x has been tested on SQL Server Active/Passive and Active/Active modes.
In both cluster modes (Active/Active or Active/Passive), Active Roles talks with <SQLDataAvailabilityGroup>\InstanceName and not with the Node\InstanceName. <SQLDataAvailabilityGroup> - is actually the Virtual Network name for the SQL Server cluster.
The application version details used while verifying SQL Cluster:Active Roles Version : Active Roles 7.3.3Database : Microsoft SQL Server 2012 Standard Edition (64-bit) (SP3) (KB3072779)Operating System : Windows Server 2012 R2 (SQL Server and Active Roles Server)Cluster type : 2 Node clusterCluster Modes : Active-Passive & Active-ActiveIn cluster mode, Active Roles or any application can talk to the database only through the SQL Virtual network name.