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.

All Supported Environments

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.

This article will summarize to resolve the error "The authenticationScheme NTLM is not valid" in MS SQL Server data source.

https://support.tibco.com/s/article/How-to-use-Windows-Authentication-for-MS-SQL-data-source-adapter-in-TIBCO-Data-Virtualization