Skip to Content
0
Aug 07, 2019 at 05:09 PM

Connect to database failed, rc=1, rcSQL=10, authentication failed

4605 Views

Hello experts,

while starting the application server (SAP S/4 HANA System) we are facing a connectivity issue:

sapcontrol:

disp+work Dispatcher, GRAY, Stopped

R3trans and dew_w0:

4 ETW000 [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ...

4 ETW000 [dbhdbsql.cpp,00000] *** 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
2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"

We checked other threads and the notes 2667891, 2250144 but did not come any further.

Which user needs to be set as a default key in the hdbuserstore - SIDadm user /SYSTEM DB user/OS user /any other user? Where do you define a password for this user - in HANA Studio, directly in hdbuserstore, somewhere else? How do you check whether the settings are consistent? How do we solve the authentication failure?

Thank you....