Product: TIBCO Spotfire Server
Versions: 11.4.0, 11.4.1, 10.10.5, 10.10.6, 11.5.0,11.6.0
Summary:
The article describes why "This driver is not configured for integrated authentication" error is seen especially with Windows integrated authentication for MSSQL database and how to solve it.
Details:
You may see the following error in tools.log when starting the configuration tool (uiconfig.bat):
ERROR 2021-10-20T11:33:49,354-0400 tools.confui.ConfigUiModel: Could not establish contact with the database: This driver is not configured for integrated authentication. ClientConnectionId:f93a6f52-2312-47b1-9ca8-78d8e9d14148
ERROR 2021-10-20T11:34:22,365-0400 tools.confui.ShowBootstrapPanel: Could not extract site from database using the information in the bootstrap file
com.spotfire.server.tools.confui.ConfigUiException: Error determining the site for server 5fc31588-ffed-4c62-b325-6f3cc9697c30
at com.spotfire.server.tools.confui.ShowBootstrapPanel.getSite(ShowBootstrapPanel.java:187) ~[spotfire-tss-tools.jar:?]
at com.spotfire.server.tools.confui.ShowBootstrapPanel.readBootstrap(ShowBootstrapPanel.java:148) [spotfire-tss-tools.jar:?]
at com.spotfire.server.tools.confui.ShowBootstrapPanel.<init>(ShowBootstrapPanel.java:99) [spotfire-tss-tools.jar:?]
at com.spotfire.server.tools.confui.BootstrapTab.useExistingBootstrap(BootstrapTab.java:393) [spotfire-tss-tools.jar:?]
at com.spotfire.server.tools.confui.BootstrapTab.tryUsingExistingBootstrap(BootstrapTab.java:459) [spotfire-tss-tools.jar:?]
at com.spotfire.server.tools.confui.ConfigurationFrame.<init>(ConfigurationFrame.java:89) [spotfire-tss-tools.jar:?]
at com.spotfire.server.tools.confui.ConfigurationMain$2.run(ConfigurationMain.java:81) [spotfire-tss-tools.jar:?]
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313) [?:?]
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:770) [?:?]
at java.awt.EventQueue$4.run(EventQueue.java:721) [?:?]
at java.awt.EventQueue$4.run(EventQueue.java:715) [?:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) [?:?]
at java.awt.EventQueue.dispatchEvent(EventQueue.java:740) [?:?]
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) [?:?]
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) [?:?]
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) [?:?]
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) [?:?]
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) [?:?]
at java.awt.EventDispatchThread.run(EventDispatchThread.java:90) [?:?]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:62b3c848-437c-4cf9-a35e-bd0823427d2a
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3206) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:72) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4015) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4004) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2768) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2418) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2265) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1291) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:881) ~[mssql-jdbc.jar:?]
at com.spotfire.server.util.sql.DriverWrapper.connect(DriverWrapper.java:67) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createStandardConnection(PoolingDataSource.java:1125) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createStandardConnection(PoolingDataSource.java:1111) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createConnection(PoolingDataSource.java:1107) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createAndInitConnection(PoolingDataSource.java:894) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.getConnection(PoolingDataSource.java:727) ~[spotfire-server.jar:?]
at com.spotfire.server.tools.confui.ShowBootstrapPanel.getSite(ShowBootstrapPanel.java:178) ~[spotfire-tss-tools.jar:?]
... 19 more
Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.2.1.x64 in java.library.path: [C:\tibco\tss\11.4.1\jdk\bin, C:\Windows\Sun\Java\bin, C:\Windows\system32, C:\Windows, C:\Windows\system32, C:\Windows, C:\Windows\System32\Wbem, C:\Windows\System32\WindowsPowerShell\v1.0\, C:\Windows\System32\OpenSSH\, C:\Users\pcherabu\AppData\Local\Microsoft\WindowsApps, .]
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:2660) ~[?:?]
at java.lang.Runtime.loadLibrary0(Runtime.java:827) ~[?:?]
at java.lang.System.loadLibrary(System.java:1871) ~[?:?]
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:51) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4014) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4004) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2768) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2418) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2265) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1291) ~[mssql-jdbc.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:881) ~[mssql-jdbc.jar:?]
at com.spotfire.server.util.sql.DriverWrapper.connect(DriverWrapper.java:67) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createStandardConnection(PoolingDataSource.java:1125) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createStandardConnection(PoolingDataSource.java:1111) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createConnection(PoolingDataSource.java:1107) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.createAndInitConnection(PoolingDataSource.java:894) ~[spotfire-server.jar:?]
at com.spotfire.server.util.sql.PoolingDataSource.getConnection(PoolingDataSource.java:727) ~[spotfire-server.jar:?]
at com.spotfire.server.tools.confui.ShowBootstrapPanel.getSite(ShowBootstrapPanel.java:178) ~[spotfire-tss-tools.jar:?]
... 19 more
ERROR 2021-10-20T11:34:37,346-0400 tools.confui.ConfigUiModel: Could not establish contact with the database: This driver is not configured for integrated authentication. ClientConnectionId:e872923b-accd-497f-8918-1f91f05ace9f
Resolution:
The issue has been addressed in TIBCO Spotfire Server versions 10.10.7 LTS, 11.4.2 LTS, and 11.7.0.
For older versions, note that this only affects the Configuration Tool when using a database driver that needs to load a native DLL. It does not affect the CLI commands or the server itself if it's started as a Windows service. The problem is specific to Windows and does not affect any Spotfire Server version on Linux.
A workaround is to copy any necessary DLL from <TSS>/tomcat/spotfire-lib or <TSS>/tomcat/custom-ext to the <TSS>/jdk/bin directory.