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

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

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

sqljdbc_11.2.0.0_enu\sqljdbc_11.2\enu\auth\x64\mssql-jdbc_auth-11.2.0.x64.dll

sqljdbc_11.2.0.0_enu\sqljdbc_11.2\enu\mssql-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 Files\Java\jdk-11.0.8\bin

C:\Program Files\Java\jdk-11.0.8\lib

C:\Program Files\TIBCO\Jaspersoft Studio-6.20.0\features\jre.win32.win32.x86_64.feature_11.0.8\adoptopenjdk_jre\bin

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

C:\Program Files\Java\jdk-11.0.8\lib

C:\Program Files\TIBCO\Jaspersoft Studio-6.20.0\features\jre.win32.win32.x86_64.feature_11.0.8\adoptopenjdk_jre\lib

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://MCDDALDWEB4011N\SQLSERVER_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 Files\TIBCO\Jaspersoft Studio-6.20.0\features\jre.win32.win32.x86_64.feature_11.0.8\adoptopenjdk_jre\lib\ 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