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.




Platform Notice: Data Center Only - This article only applies to Atlassian products on the data center platform.

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.