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

• Create connection in Datasphere using HANAAdapter.
• Validated the connection and it failed with "authentication failed" error.
• In framework.trc file, there is the 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 and password are correct by logging to HANA with the same information. The error is misleading.

• SAP HANA Smart Data Integration
• Datasphere

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