3462480 - Error "Adapter validation failed" in Microsoft SQL Server Connection - SAP Datasphere

Remote Table error is raised during validation of Microsoft SQL Server connection created in SAP Datasphere

Connection <Connection_name> couldn’t be established.

- Remote tables can’t be used because of errors in the connection.

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

SAP Datasphere

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

Adapter's version is not supported.

• Make sure to use a jdbc jar file listed in the 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.

• Prepare Connectivity to Microsoft SQL Server
• Preparing Data Provisioning Agent Connectivity
• Register Adapters with SAP Datasphere
• SAP HANA smart data integration and all its patches Product Availability Matrix (PAM) for SAP HANA SDI 2.0

mssql, jdbc, connection, Datasphere, driver, mssqllogreadadapter, adapter, SDI , KBA , DS-DI-CON , Connections , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem