Symptom
During the upgrade of an SAP system based on SAP NetWeaver, the connection from the shadow instance to the HANA database fails with the following error:
C Try to connect via secure store (UPGSHDKEY) on connection 0 ...
C *** ERROR => Connect to database failed, rc=1, rcSQL=10
[dbhdbsql.cpp 419]
C SQLCODE : 10
C SQLERRTEXT :authentication failed
B ***LOG BY2=> sql error 10 performing CON [dbsh 1262]
B ***LOG BY0=>authentication failed [dbsh 1262]
B ***LOG BY2=> sql error 10 performing CON [dblink 644]
B ***LOG BY0=>authentication failed [dblink 644]
M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 86]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2551]
However, using the <sid>adm user to test test the connection with hdbsql -u or hdbsql -U, using the shadow instance user or key, it works.
Read more...
Environment
- SAP HANA, platform edition;
- SAP NetWeaver;
- Windows Server;
Product
SAP HANA, platform edition all versions ; SAP NetWeaver all versions
Keywords
shadow, shd, hdb, keystore, userstore, sidadm, default, No mapping between account names and security IDs was done , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.