Error "This driver is not configured for integrated authentication" while accessing the TIBCO Spotfire Server Configuration tool
Article ID: KB0072608
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 11.4.0, 11.4.1, 10.10.5, 10.10.6, 11.5.0,11.6.0 |
Description
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
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
Issue/Introduction
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.
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.
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.
Additional Information
Doc: Opening the configuration tool
Feedback
Yes
No
Powered by
