SAP Knowledge Base Article - Preview

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.


    Read more...

    Environment

    SAP Datasphere

    Product

    SAP Datasphere all versions

    Keywords

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

    About this page

    This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

    Search for additional results

    Visit SAP Support Portal's SAP Notes and KBA Search.