Cannot connect JDBC connection data adapter to MS SQL server database - driver is not configured for integrated authentication

[andrew.ladow]

I installed Jaspersoft Studio v6.20.0. I’m trying to connect Jaspersoft Studio to a Microsoft SQL Server database using a JDBC connection data adapter. When I click the test button once, a dialog box appears that says ‘Successful’. When I click the test button a second time, an exception returns that reads: “This driver is not configured for integrated authentication. Unable to load authentication DLL mssql-jdbc_auth-11.2.0.x64” I’ve pasted the full error below.

 

I’ve installed Java SE Development Kit 11.0.8 (link to install file: https://www.oracle.com/java/technologies/javase/jdk11-archive-downloads.html).

 

I’ve also downloaded Microsoft JDBC Driver for SQL Server and extracted files:

sqljdbc_11.2.0.0_enusqljdbc_11.2enuauthx64mssql-jdbc_auth-11.2.0.x64.dll

sqljdbc_11.2.0.0_enusqljdbc_11.2enumssql-jdbc-11.2.0.jre11.jar

 

I’ve copied the mssql-jdbc_auth-11.2.0.x64.dll file to the following folders:

C:Program FilesJavajdk-11.0.8bin

C:Program FilesJavajdk-11.0.8lib

C:Program FilesTIBCOJaspersoft Studio-6.20.0featuresjre.win32.win32.x86_64.feature_11.0.8adoptopenjdk_jrebin

 

I’ve copied the mssql-jdbc-11.2.0.jre11.jar file to the following folders:

C:Program FilesJavajdk-11.0.8lib

C:Program FilesTIBCOJaspersoft Studio-6.20.0featuresjre.win32.win32.x86_64.feature_11.0.8adoptopenjdk_jrelib

 

My data adapter database JDBC connection details are listed below:

 

>Database Location

Name: UWD_MCDONALDS_PROD

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Url: jdbc:sqlserver://MCDDALDWEB4011NSQLSERVER_PWP2_0;instanceName=SQLSERVER_PWP2_0;databaseName=UWD_MCDONALDS_PROD;IntegratedSecurity=True;TrustServerCertificate=True

>Driver Classpath

Name: UWD_MCDONALDS_PROD

Jar Files Path: C:Program FilesTIBCOJaspersoft Studio-6.20.0featuresjre.win32.win32.x86_64.feature_11.0.8adoptopenjdk_jrelib mssql-jdbc-11.2.0.jre11.jar

net.sf.jasperreports.engine.JRException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:bf4293dc-511a-4231-a2ea-1f84bc8f7394

                at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:127)

                at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:120)

                at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:154)

                at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51)

                at java.base/java.lang.Thread.run(Unknown Source)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:bf4293dc-511a-4231-a2ea-1f84bc8f7394

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

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

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

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

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

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

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

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

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

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

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

                at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:181)

                at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:125)

                ... 4 more

Caused by: java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc_auth-11.2.0.x64

                at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:63)

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

                ... 14 more

[christoph.nieswand]

Any progress here? I have exactly the same problem. It is a classloader problem: 

It happens with all versions of Jaspersoft Studio which is running with JRE 11. Tried with different mssql-driver versions - always the same.

[ramadhanalfatih10]

Already got the solution? I need the solution so bad

 

[jigar.patel_1]

Any solution to this?? Please please help. exactly stuck at this issue.