How to Configure Jira Align Self-Hosted with SQL Server in Always-On configuration?

Summary

This article describes on the additional configuration required on the the SQL connection string when the SQL server is configured as a Always-on with the availability group listener name defined as the SQL hostname.

Environment

Jira Align Self-hosted

Solution

1. By default the connection string provided in the Jira Align config file contains Data Source which connects to the SQL server defined.

   <add name="Main" connectionString="Data Source={Data Source};Initial Catalog={Initial Catalog};Integrated Security=False;User Id={SQL User Name};Password={SQL Password};Encrypt=yes;TrustServerCertificate=True;MultipleActiveResultSets=True;" />

2. When the Data Source is defined as Always-On Availability group listener name, the above connection string only connects to the primary node of the group but does not attempt to look for a failover server in case the primary node goes down.

3. Add the following connection property to the SQL connection string → MultiSubnetFailover=True

4. The connection string should look like below:

   <add name="Main" connectionString="Data Source={Data Source};Initial Catalog={Initial Catalog};Integrated Security=False;User Id={SQL User Name};Password={SQL Password};Encrypt=yes;TrustServerCertificate=True;MultiSubnetFailover=True;MultipleActiveResultSets=True;" />

5. The connection string has to be updated for all the config files: Web Services on _cust\web.config, Connector services - AgileCraft_Jira.exe.Config, Backoffice service - AgileCraft.Backbone.dll.Config