3474638 - SAP Datasphere "authentication failed" error connecting to SAP HANA DB

• There is a requirement to connect an on-premise HANA database to SAP Datasphere.
• The Data Provisioning Agent has been installed.
• The necessary steps as per Prepare Connectivity to SAP HANA and Preparing Data Provisioning Agent Connectivity have been completed. 
• Validating a HANA Database connection to the SAP Datasphere Data Provisioning Agent results in the following errors: 
  • Unable to connect remote source: Error occurred when connecting to Hana database. Error: [10]: authentication failed., Code: 5921, SQL State: HY000
  • Remote Tables: Unable to connect remote source: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed, Code: 5921, SQL State: HY000

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP Datasphere

1. Configure the SAP HANA connection with Authentication Type: User Name And Password
   
   
2. Use the Validate option in Datasphere to test the connection. 

The SAP HANA Credentials of the connection are incorrect. 

1. Check and verify the logon credentials. 
2. If possible, try to logon directly to the DB with the same credentials.

• KBA 2938870 Errors when connecting DP Agent with SAP Datasphere
  
  
• SAP Help Troubleshooting the Data Provisioning Agent (SAP HANA Smart Data Integration)
• SAP Help Preparing Connectivity for Connections
  
  
• DP Agent Troubleshooting Guide

DPA, DP Agent, Data Provisioning Agent, authorization, framework trace, login, logon , KBA , DS-DI-CON , Connections , Problem