Symptom
- Test connection failed for MSSQL remote source through MssqlLogReaderAdapter with Windows Authentication.
- Error: "DPFramework | WorkerThread.processRequest - com.sap.hana.dp.adapter.sdk.AdapterException: Adapter validation failed. [Remotesource_name]Failed to establish JDBC connection. Error: Login failed for user***".
- Change remote source to use SQL Server user, test connection successfully.
- DP Agent installed on Linux server.
Read more...
Environment
SAP HANA Smart Data Integration
Product
SAP HANA smart data integration 2.0
Keywords
DP agent, Linux, Windows, sql, Windows Authentication, AD, MssqlLogReaderAdapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview