Symptom
- You have updated the password in the hdbuserstore by using the following command:
hdbuserstore SET <KEY> <ENV>[@<DATABASE>] <USERNAME> <PASSWORD> - When you attempt to login by using hdbsql -U <KEY> you get the following error:
* 10: authentication failed SQLSTATE: 28000 - It may also cause application that depends and use hdbuserstore keys to fail such as ABAP Application servers. R3trans connection tests will fail with the following error:
*** ERROR => Connect to database failed, rc=1, rcSQL=10
4 ETW000 [ dev trc,00000] SQLCODE : 10
4 ETW000 [ dev trc,00000] SQLERRTEXT : authentication failed
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 10 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>authentication failed
"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 HANA Platform;
- SAP NetWeaver;
- SAP S/4HANA;
- SAP BW/4HANA;
Product
SAP BW/4HANA all versions ; SAP HANA, platform edition all versions ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP S/4HANA all versions
Keywords
authentication, failed, invalid, incorrect, password, pasword, pass word, performing CON, sql error 10 , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , BC-DB-HDB-SYS , Database Interface/DBMS for SAP HANA , 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.