Warning Message "The data source 'xxxxx' using NTLM authentication requires manual update" after TIBCO Spotfire Server upgrade
Article ID: KB0077357
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 10.3 and higher |
Description
While upgrading to Spotfire 10.3 or higher, the following warning may be seen after the upgrade is completed:
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.
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.
Issue/Introduction
This article explains the reason for the warning "The data source 'xxxxx' using NTLM authentication requires manual update" shown in the upgrade tool of TIBCO Spotfire Server
Resolution
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:
- Log in to TIBCO Spotfire Analyst and go to Data > Information designer > Data Sources.
- Select the data source that needs to be updated, right click on it and select "Edit".
- Update the Username and Password section with credentials that can access the data source.
- Click "Save".
Additional Information
Feedback
Yes
No
Powered by
