Getting a "This driver is not configured for integrated authentication" error with database import configuration
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Problem
You are configuring for database import as per Insight - Database Import. You are unable to proceed to the next screen due to a warning/error about the database connection URL that goes like this:
1
This driver is not configured for integrated authentication. ClientConnectionID:<clientconnectionid>Diagnosis
Environment
The URL is configured correctly to connect to a MSSQL database and Windows authentication is being used. The connection URL is based on Microsoft's documentation.
Diagnostic Steps
The connection is possible with Microsoft Management Studio or other Microsoft-based applications.
The connection is not possible with a non-Microsoft-based application like DBeaver, DbVisualizer with the same connection details as what have been configured for the import.
Cause
This is not an issue with the Insight integration but a commonly seen SQLServerException with MSSQL. This could happen is some DLL files are not installed the Jira server.
Solution
Resolution
Depends on the version of the JDBC driver, install the missing DLL files in Jira server accordingly.
In the MSSQL JDBC driver installation directory, locate and copy the sqljdbc_auth.dll or mssql-jdbc_auth-<version>-<arch>.dll file to the Java bin directory. Test the import configuration again.
Was this helpful?