Warning Message "The data source 'xxxxx' using NTLM authentication requires manual update" after TIBCO Spotfire Server upgrade

Warning Message "The data source 'xxxxx' using NTLM authentication requires manual update" after TIBCO Spotfire Server upgrade

While upgrading to Spotfire 10.3 or higher, the following warning may be seen after the upgrade is completed:

The data source MYDATASOURCE using NTLM authentication requires manual update
The DLL-based NTLM authentication method has been removed from the DataDirect JDBC driver for Microsoft SQL Server. The configuration
of the data source has been updated to use a Java-based NTLM authentication method that requires a user and a password to be specified. 
Please update the data source with a user and a password, or switch to another authentication method such as Kerberos.

Example:


This is because the data sources mentioned in the warning are using NTLM authentication to Microsoft SQL Server through TIBCO DataDirect SQL Server JDBC driver. Starting Spotfire 10.3, this driver does not support DLL-based NTLM authentication that automatically uses the account running the Spotfire server service to authenticate against the data source. Instead, this driver now supports java based NTLM authentication which takes a username and password that is entered manually, while saving the data source in Information Designer. If NTLM authentication was used in the data source before upgrading to Spotfire 10.3, a manual username and password must be entered for data source authentication. This can be done by editing the data source from Information Designer. Below are the steps to perform this:

1. Log in to TIBCO Spotfire Analyst and go to Data > Information designer > Data Sources.
2. Select the data source that needs to be updated, right click on it and select "Edit".
3. Update the Username and Password section with credentials that can access the data source.
4. Click "Save".

See the Data Source Tab reference for more details. Doc: Data Source Tab

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_data_source_tab.htm