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

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

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.

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". 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