SAP Knowledge Base Article - Public

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

    Reproducing the Issue

    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.

    See Also


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


    SAP Datasphere 1.0


    Pasted image.png