Creating a TIBCO Spotfire Server bootstrap file fails with error "This driver is not configured for integrated authentication"

book

Article ID: KB0075387

calendar_today

Updated On:

Products	Versions
Spotfire Server	7.5 and higher

Description

Spotfire administrators may see the following error when trying to create a bootstrap file for the TIBCO Spotfire Server using the Microsoft SQL Server (MSSQL) JDBC driver with Integrated Authentication:

 There was an error connecting to the Spotfire Server Database: This driver is not configured for integrated authentication.

Issue/Introduction

Creating a TIBCO Spotfire Server bootstrap file fails with error "This driver is not configured for integrated authentication"

Resolution

To resolve this issue, ensure that:

The file "sqljdbc4.jar" (and no other version of MSSQL JDBC Driver) is present in "<Server Installation Directory>\tomcat\spotfire-lib" folder.
The file "sqljdbc_auth.dll" is present in "<Server Installation Directory>\tomcat\spotfire-lib" folder. For version 10.3.9, the file "mssql-jdbc_auth-8.2.2.x64.dll" needs to be present in "<Server Installation Directory>\tomcat\spotfire-lib".

Note: For versions prior to 10.3, the "sqljdbc4.jar" and the "sqljdbc_auth.dll" file are located under "<Server Installation Directory>\tomcat\lib".

Additional Information

Doc: Setting up the Spotfire database (SQL Server with Integrated Windows authentication)

https://docs.tibco.com/pub/spotfire_server/10.3.3/doc/html/TIB_sfire_server_tsas_admin_help/GUID-58075A75-BA21-4564-996F-1135A7C8CC01.html

Doc: Creating the bootstrap.xml file

https://docs.tibco.com/pub/spotfire_server/10.3.3/doc/html/TIB_sfire_server_tsas_admin_help/GUID-24E553B2-54F9-46BD-A8B7-A1EA914155C0.html

Feedback

thumb_up Yes

thumb_down No

Welcome to "KB Articles"