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 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.0.2.2193Database : 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.Active Roles is associated with the given SQL instance and therefore a clustered or non-clustered database is not relevant.
Leave a Comment
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- Contact Us
- Technical Support
- View All
- Product(s):
-
Active Roles
7.0.4, 7.0.3, 7.0.2, 7.0, 6.9
- Topic(s):
- Best Practices
- Article History:
- Created on: 3/24/2016
Last Update on: 7/15/2016
- Author:
- Darryl Johnson
- Search All Articles
-