Summary

This article describes on how to verify whether SQL server is using a default port 1433 or a custom port and how to configure Jira Align Self-Hosted with a custom SQL Port

Environment

Jira Align Self-Hosted

Solution

Step 1: Verify and determine if SQL is using the default port or custom port.

• Open SQL Server Configuration Manager > SQL Server Network configuration > Protocols for $INSTANCE_NAME$ > TCP/IP > right click > Properties > IP Addresses > IPv4/IPAll > TCP Port
• If the port defined is 1433, SQL server is using default port and no special configuration is required
• If the port defined is not 1433, SQL server is using a non-default port
• Note the port number defined
• Example screenshot:
  
• Refer to https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port on how to configure custom port for SQL

Step 2: Confirm that connection can be established using the custom SQL port via SQL Server Management Studio to Jira Align Database using the Server Name as <SQL_Server_Name>,<custom_port>

• Example Screenshot:
  

Step 3: 

• SQL Server name is defined under three files during the installation process:
  • For Web Application - <Install_Drive>:\<JA_customer_name>\_Cust\web.config
  • For each connector, <Install_Drive>:\<JA_customer_name>\<Jira_x>\AgileCraft_Jira.exe.config
  • For Backoffice Service prior to 10.130:  <Install_Drive>:\<JA_customer_name>\BackofficeService\AgileCraft.Backbone.exe.config
  • For BackOffice Service for 10.130 and above: <Install_Drive>:\<JA_customer_name>\BackofficeService\AgileCraft.Backbone.dll.config
• In the above files, define the SQL server name in the SQL connection String as Data Source=<SQL_Server>,<custom_port>

  • Example Syntax

    <add name="Main" connectionString="Data Source=<SERVERNAME>,<custom_port>;Initial Catalog=<JA_DB>;Integrated Security=False;User Id=<SQL_admin>;Password=<SQL_pwd>;MultipleActiveResultSets=True;Encrypt=yes;TrustServerCertificate=True;" />

  • Example based on the above screenshot:

    <add name="Main" connectionString="Data Source=EC2AMAZ-32CB98R,7655;Initial Catalog=ABCCORP;Integrated Security=False;User Id=sa;Password=12345678;MultipleActiveResultSets=True;Encrypt=yes;TrustServerCertificate=True;" />

Related Articles

• How to setup Jira Align Self-Hosted with non-default SQL instance
• How to setup Jira Align Self-Hosted with non-default SQL instance and custom SQL Port