Jira Database on Azure MSSQL using Microsoft AD/Entra authentication

[Zouhair Ouhdid]

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

[HIMANSHU KUMAR]

Hi @Zouhair Ouhdid ,

Why not you are using Authentication Method by Jira DC free of cost. In Azure you need to create application for Jira DC and you need to create authentication method in Jira also.

[Zouhair Ouhdid]

hi, i think that is related to authenticating users to jira , for my case i am trying to connect JIRA to azure database using entra id