JIRA to Azure MSSQL using Microsoft Entra Authentication

Question

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

* When using mssql-jdbc_auth-12.6.0.x64.dll :

Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.2.1.x64 in java.library.path: E:\Atlassian\Jira\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;E:\Atlassian\Jira\bin\..\jre\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;E:\Atlassian\Jira\jre\bin;C:\Users\WEZ-DITEJ-001SQL-D01\AppData\Local\Microsoft\WindowsApps;.

at java.base/java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.base/java.lang.Runtime.loadLibrary0(Unknown Source)

* When using no mssql-jdbc_auth-9.2.1.x64 :

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:d386b6e9-83ca-4755-8877-3f935d3fbd85

at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3206)

at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:72)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4015)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4004)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2768)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2418)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2265)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1291)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:881)

at java.sql/java.sql.DriverManager.getConnection(Unknown Source)

Zouhair Ouhdid · Answer

hi, thanks for your feedback i have a new error with mssql-jdbc_auth-9.2.1.x64.dll: 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 : defaultDS

default

mssql

dbo

jdbc:sqlserver://wezditejsdsp0001.database.windows.net:1433;databaseName=DITEJ-jira-db01;integratedsecurity=true;

com.microsoft.sqlserver.jdbc.SQLServerDriver

dummyuser dummypassword

40

30000

select 1

60000

300000

40

true

300

false

true

PI : we are using azure MSSQL with Microsoft Entra authentication for the DB so may be how to implement Microsoft Azure Entra authentication for Jira

Ignacio Aredez GenAI Expert · Answer

To address the issues you're encountering with connecting JIRA Data Center to Azure SQL using Azure AD authentication, let's simplify the troubleshooting steps:

Issue 1: UnsatisfiedLinkError for mssql-jdbc_auth-12.6.0.x64.dll
Verify DLL Placement: Make sure the mssql-jdbc_auth-12.6.0.x64.dll is in a directory listed in the java.library.path. The error indicates it might be missing or not correctly referenced.
Check Version Consistency: Ensure the version of the mssql-jdbc_auth DLL matches the one expected by your system and JIRA configuration. Update references if there's a mismatch.

Issue 2: Driver Not Configured for Integrated Authentication
Correct Connection String: Ensure your dbconfig.xml for JIRA correctly specifies the use of integrated authentication, fitting the requirements for Azure AD.
JDBC Driver Support: Make sure you're using a JDBC driver version that supports Azure AD authentication. Update if necessary.

General Steps:
Update Environment Variables: If you added or updated the DLL, add its directory to your system's PATH and restart JIRA.
Review Documentation: Double-check Atlassian and Microsoft's documentation to ensure all steps for Azure AD authentication are correctly followed.