How to resolve The authenticationScheme NTLM is not valid in TIBCO Data Virtualization on MS SQL Server?
Article ID: KB0070035
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
After setting up the NTLM Authentication in TDV for the MS SQL Server data source, the user can get the error "The authenticationScheme NTLM is not valid" while making a test connection to the data source.
Issue/Introduction
This article will summarize to resolve the error "The authenticationScheme NTLM is not valid" in MS SQL Server data source.
Environment
All Supported Environments
Resolution
The authenticationScheme NTLM is not valid error indicates that the SQL JDBC jar version file being used does not support the NTLM authentication scheme. In TDV, the Microsoft SQL Server JDBC driver can be found inside the <TDV install directory>/conf/adapters/system/microsoft_sql_server_<version>/mssql-jdbc-<version>.jar.
Support for NTLM authentication in Microsoft SQL Server JDBC drivers started with the Microsoft JDBC Driver 6.0 for SQL Server and hence to use NTLM authentication, the user should be using >= v6.0.0 of MS SQL JDBC driver.
Support for NTLM authentication in Microsoft SQL Server JDBC drivers started with the Microsoft JDBC Driver 6.0 for SQL Server and hence to use NTLM authentication, the user should be using >= v6.0.0 of MS SQL JDBC driver.
Additional Information
https://support.tibco.com/s/article/How-to-use-Windows-Authentication-for-MS-SQL-data-source-adapter-in-TIBCO-Data-Virtualization
Feedback
Yes
No
Powered by
