Getting a "This driver is not configured for integrated authentication" error with database import configuration
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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
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:
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.
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.