hi Team,
i have some errors when trying to connect JIRA datacenter to Azure SQL using azure AD authentication , i followed the article : https://confluence.atlassian.com/jirakb/use-integrated-authentication-with-sql-server-in-jira-server-939494383.html
Version : Jira 9.11.0
- Error:
2024-02-19 10:42:31,402+0000 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
com.microsoft.sqlserver.jdbc.SQLServerException: Windows logins are not supported in this version of SQL Server. ClientConnectionId:7f685a0b-2282-4bce-9827-cc0c61763de3
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
- below my dbconfig.xml :
<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>dbo</schema-name>
<jdbc-datasource>
<url>jdbc:sqlserver://wezditejsdsp0001.database.windows.net:1433;databaseName=DITEJ-jira-db01;integratedsecurity=true;</url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<username>dummyuser</username>
<password>dummypassword</password>
<pool-min-size>40</pool-min-size>
<pool-max-size>40</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>40</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
</jdbc-datasource>
</jira-database-config>
FYI : we are using azure MSSQL with Microsoft Entra authentication for the DB
so may be how to implement Microsoft Azure Entra authentication for Jira
