DV connection to MS SqlServer returns error: "authentication value "BASIC" is not valid "

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.