epainley
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by epainley
-
-
Anyone? I find it hard to believe nobody is using SQL server.
-
I have to connect Jaspersoft Studio to a SQL 2008 R2 database using the Microsoft JDBC 4.0 drivers supplied from the Microsoft website. I have downloaded the official drivers for my JDK architecture and I have added the sqljdbc4.jar and sqljdbc_auth.dll to the driver classpath page and I am able to connect using integrated Windows authentication the first time but if I click Test again or attempt to run a report I get the following error "Native Library C:WindowsSystem32sqljdbc_auth.dll already loaded in another classloader".
Note this is a similar question to the same problem in sql-server-connection-jaspersoft-studio however it is not an architecture problem as the driver works the first time and the JDK and the sqljdbc_auth.dll are the correct identical architectures. Here is the full stack trace and JDBC Url:
jdbc:sqlserver://sqltest.domain.local:1433;instanceName=DOMAIN;databaseName=TestDB;integratedSecurity=true[/code]
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:76549b69-e848-404f-9a02-64341a768b76
net.sf.jasperreports.engine.JRException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:76549b69-e848-404f-9a02-64341a768b76
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:130)
at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)
at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)
at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)
at java.lang.Thread.run(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:76549b69-e848-404f-9a02-64341a768b76
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:60)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2229)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:168)
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
... 4 more
Caused by: java.lang.UnsatisfiedLinkError: Native Library C:Windowssqljdbc_auth.dll already loaded in another classloader
at java.lang.ClassLoader.loadLibrary1(Unknown Source)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:35)
... 15 more
SQL Server connection with integrated authentication in Jaspersoft Studio
in Products
Posted
Probably not the best solution but place the sqljdbc4.jar in C:Program Files (x86)TIBCOJaspersoft Studio-6.1.0.finalfeaturesjre.win32.win32.x86.feature_1.7.0.u80jrelibext and the sqljdbc_auth.dll in C:Program Files (x86)TIBCOJaspersoft Studio-6.1.0.finalfeaturesjre.win32.win32.x86.feature_1.7.0.u80jrebin