SAP Knowledge Base Article - Public

3462480 - "Adapter validation failed" error when validating MS SQL connection

Symptom

Error is raised during validation of Microsoft SQL Server connection created in SAP Datasphere

Connection "Connection_name" couldn’t be established. - Data flows can’t be used because of errors in the connection. - Replication flows are not supported. - Remote tables can’t be used because of errors in the connection.
Data Flows: Cause: Timed out while connecting to the source
Remote Tables: Unable to connect remote source: Adapter validation failed. [XXX_XXX.XXX]Failed to establish JDBC connection. Error: This driver is not configured for integrated authentication. ClientConnectionId:XXXXXXXXXXXXXXXXX, Code: 5921, SQL State: HY000

Correlation ID: xxxxxx-xxxxx-xxxx

Environment

SAP Datasphere

Reproducing the Issue

  1. Go to Connections
  2. Select the Microsoft SQL Server connection
  3. Choose validate

Cause

Adapter's version is not supported

Resolution

  • Make sure to use a jdbc jar file listed in our PAM document, for example: mssql-jdbc-9.2.0.jre8.jar
  • Only one mssql jar file have to be listed under the lib folder
  •  The mssql-jdbc_auth-xxxx.dll (xxxx to be replaced with the used version) is copied to the C:\usr\sap\dataprovagent\sapjvm\bin directory. It can be found in the install zip in \sqljdbc_xxxx\enu\auth\x64 directory.

See Also

Preparing Data Provisioning Agent Connectivity

Keywords

mssql, jdbc, connection, Datasphere, driver, mssqllogreadadapter  , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions