3224592 - DWC connection through HANAAdapter failed with error : "authentication failed"

• Create connection in DWC through HANAAdapter
• Validate the connection and failed with "authentication failed" error.
• From framework.trc file, we can see following error
  DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: Error occurred when connecting to Hana database. Error: [10]: authentication failed. Context: com.sap.db.jdbc.exceptions.SQLInvalidAuthorizationSpecExceptionSapDB: [10]: authentication failed
                                  at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:183)
                                  at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:42)
• Confirm the user/password is correct through logon to HANA with the same information, the error is misleading

SAP HANA Smart Data Integration

SDI, hana, connection, failed, validate, authentication , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem