Error while executing the TIBCO Spotfire Server 'uiconfig' batch file from the 'spotfireconfigtool' folder: "Could not establish contact with the database: This driver is not configured for integrated authentication"

Error while executing the TIBCO Spotfire Server 'uiconfig' batch file from the 'spotfireconfigtool' folder: "Could not establish contact with the database: This driver is not configured for integrated authentication"

book

Article ID: KB0073366

calendar_today

Updated On:

Products Versions
Spotfire Server 7.11.x and higher

Description

The configuration tool offers the most frequently used configuration options and generally, we run the configuration tool from a local/remote machine other than the Spotfire server machine.

The configuration tool may return the below error, while using integrated authentication method  to connect to the Spotfire Server Database

====================
Could not establish contact with the database: This driver is not configured for integrated authentication. ClientConnectionId:92b21998-d87e-46cb-bcc3-2820e726d0a1
====================

User-added image

Note: 1) We can verify the authentication method in the bootstrap.xml file e.g. jdbc:sqlserver://servername:1433;DatabaseName=spotfire_server; integratedSecurity=true
2) This article is not applicable for TIBCO Spotfire Server 10.3.9 version. Reference article for 10.3.9 -  https://support.tibco.com/s/article/Error-while-launching-uiconfig-tool-in-spotfireconfigtool-folder-when-Spotfire-database-Microsoft-SQL-Server-setup-with-Integrated-Windows-authentication
  

Issue/Introduction

Error while executing the 'uiconfig' batch file from the 'spotfireconfigtool' folder: "Could not establish contact with the database: This driver is not configured for integrated authentication"

Environment

All

Resolution

To resolve the above reported error, copy the corresponding 'sqljdbc_auth.dll' file inside the 'spotfireconfigtool' folder NOT inside the '<Spotfireconfigtool>/lib' folder. Below is the screenshot for the reference:

User-added image