Adobe Connect Clusters with SQL AlwaysOn

This article applies to on premise installations of Adobe Connect servers.

Adobe Connect version 11.0 is the minimum version required for use with MSSQL AlwaysOn. We recommend updating to the latest patched version of Adobe Connect server.

DB_NAME=<Connect DB Name>
DB_HOST=<Availability Group Listener> 
DB_PORT=1433
DB_USER= <user>
DB_PASSWORD= <password>

#Always-On – Single subnet
DB_URL=jdbc:adobe:sqlserver://{DB_HOST}:{DB_PORT};databaseName={DB_NAME};user={DB_USER};password={DB_PASSWORD};FailoverMode=extended

#Always-On – Multi-subnet
DB_URL=jdbc:adobe:sqlserver://{DB_HOST}:{DB_PORT};databaseName={DB_NAME};user={DB_USER};password={DB_PASSWORD};FailoverMode=extended;MultiSubnetFailover=true

With Always On architecture, the DB_HOST variable becomes the AlwaysOn Listener address instead of the SQL server hostname. If Always On replicates across different subnets or the DB servers belong to different subnets, add MultiSubnetFailover=true in the jdbc DB_URL.