SAP Knowledge Base Article - Preview

3638492 - Application server fails to start due to sql error 10 authentication failure after changing password of HANA account

Symptom

  • SAP application server running on Windows server fails to start after changing the password for HANA accounts(including the account used by ABAP AS to connect to HANA).
  • The following error message "SQLERRTEXT: authentication failed" is observed in the dev_w traces.
    • C  *** ERROR => Connect to database failed, rc=1, rcSQL=10
       [dbhdbsql.cpp 647]
      C  SQLCODE    : 10
      C  SQLERRTEXT : authentication failed
      B  ***LOG BY2=> sql error 10     performing CON [dbsh         1289]
      B  ***LOG BY0=> authentication failed [dbsh         1289]
      B  ***LOG BY2=> sql error 10     performing CON [dblink       689]
      B  ***LOG BY0=> authentication failed [dblink       689]
      M  
      M Wed Jul 23 17:25:33:121 2025
      M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 88]
      M  in_ThErrHandle: 1
      M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2808]
  • The password in the secure store key is correct, and this error was not fixed even after deleting the key entry and re-add it to hdbuserstore.
  • 'hdbsql -U' and 'R3Trans -d' do not return any errors.

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


Read more...

Environment

SAP HANA 2.0

Product

SAP HANA, platform edition 2.0

Keywords

SQL error 10, rcSQL=10, authentication failed, application server , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.