Jira Align does not support Windows Authentication for SQL Connection
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
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
Jira Align deployment requires SQL Authentication between the IIS Web Server, Connectors services, back office service, and the deployment script to the SQL Server.
Solution
It is not possible to use Windows Authentication, the SQL User credentials must be added explicitly to the config files of each service.
The official information is that it's not currently supported and there are no plans to change it.
SQL Server has 2 authentication modes. One Is the Windows Authentication Mode and the second is the Mixed mode, which is the only one that allows us to use SQL auth. That's why mixed mode is a requirement for Jira Align, because it requires SQL and not because it supports both
Was this helpful?