DV connection to MS SqlServer returns error: "authentication value "BASIC" is not valid "
book
Article ID: KB0082341
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
7.0.0 and later
Description
When connecting from TDV to a MS SqlServer as a datasource, you see the error:
Cause: The authentication value "BASIC" is not valid com.compositesw.cdms.datasource.DataSourceException: The authentication value "BASIC" is not valid.
Check your sqljdbc41.jar OR sqljdbc42.jar that you are using to support the MS adapter. You will need to check the timestamp of the various files inside the .jar archive. If you see a year of 2017 or later, those are the drivers when MS stopped supporting "BASIC".
There are 2 workarounds:
1) Obtain an earlier build of the MS .jar file that was compiled in 2016 and use that instead.
OR
2) Add two new jdbc connection properties to your MS SqlServer datasource. In the Advanced tab of the datasource, see the JDBC Connection Properties. Add these 2 new properties with their respective value.
Property Value -------------------------------------------------------------------------- authenticationScheme NativeAuthentication authentication NotSpecified
Either of these will resolve the "BASIC" error. There is currently an open bug (CIS-65521) for Tibco to investigate a permanent solution.
Issue/Introduction
This discusses the Microsoft JDBC drivers for SqlServer.