Getting a "This driver is not configured for integrated authentication" error with database import configuration

Still need help?

The Atlassian Community is here for you.

Ask the community


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 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

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.



DescriptionGetting a "This driver is not configured for integrated authentication" error with MSSQL database import configuration
ProductJira Service Management, Insight

Last modified on Oct 29, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.