Product: TIBCO Spotfire®
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"
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
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
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: