Jira Align does not support Windows Authentication for SQL Connection

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