SAP Knowledge Base Article - Preview

3411419 - HANA Cloud ODBC connection error: No password set for the user XXXX

Symptom

ODBC connection test with user XXXX is successful, you also able to logon the database with user XXXX.

The most strange thing is that, when trying to leverage ODBC from the application, there will be an authentication error triggered:

  • [unixODBC][SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed: Detailed info for this error can be found with correlation ID '123abc456def789ghi213hyriywqegiyg1yg'

After parse the correlation ID string with below query:

  • select reason from authentication_error_details where correlation_id = '123abc456def789ghi213hyriywqegiyg1yg';

You will find the authentication failure REASON is: No password set for the user XXXX. 


Read more...

Environment

  • HANA Cloud 1.0 and higher

Product

SAP HANA Cloud 1.0 ; SAP HANA service 1.0 for SAP BTP

Keywords

authentication failed, correlation ID,  No password set for the user, migration, HANA service, HANA cloud, unixODBC, SAP AG, LIBODBCHDB SO, HDBODBC , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-CLS-HC , HANA Cloud Services HANA Cloud , HAN-CLS-DB , HANA Database as a Service , HAN-CLS-MIG , SAP HANA Cloud Migration , 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.