SAP Knowledge Base Article - Public

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

Symptom

  • There is a requirement to connect an on-premise SAP 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.

    Environment

    SAP Datasphere

    Reproducing the Issue

    1. Configure the SAP HANA connection with Authentication Type: User Name And Password


    2. Use the Validate option in SAP Datasphere to test the connection. 

    Cause

    The SAP HANA Credentials of the connection are incorrect. 

    Resolution

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

    See Also

    Keywords

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

    Product

    SAP Datasphere all versions