Search

Your Notifications (0)

There are currently no notifications. You're all set!

Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Error "This driver is not configured for integrated authentication" while accessing the TIBCO Spotfire Server Configuration tool

Rich Talbot

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.

Related articles

Comments

0 comments

Article is closed for comments.