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

If anyone encounters this same problem, I've been able to solve this on my own via sub-reports. This approach didn't work for me on my first attempt because I wasn't thinking logically (a common occurance). Put simply, the sub-report needs to be the report that is going to generate multiple rows and the main report should only contain the cells you want merged across those multiple rows. Push the sub-report to the back, strectch the content of the cell you want merged to fit the band, and there you have it. Probably not the most efficient method to use, however, this worked for me.

Does anyone know how to merge cells in the middle column of a table in Jaspersoft Studio? I've tried to do this using different settings on a table created manually using text fields (displayed below), however, I need the value 'Static Text' under the column 'Constant Value' to be stretched down through each row. I also need the value 'Static Text' to be centered in the table (not just in the top row). I've tried to accomplish this by using a table element, a crosstab, a subreport, a frame, a group, and nothing has worked. I've searched pretty extensively in this forum, stack overflow, and other places; it looks like a few people have had a similar questions but I couldn't find any answers to resolve my particular issue. Can anyone help, please (I'm really desperate here)?!?!?