How to Configure Jira Align Self-Hosted with SQL Server in Always-On configuration?
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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
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;" />
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.
Add the following connection property to the SQL connection string → MultiSubnetFailover=True
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;" />
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
Was this helpful?