Connect to database failed : SQL STATE 28000

[former_member1327483]

Dear All

After performing system restoration activity through hana studio, application is unable to connect to DB. I am getting R3trans error - 12 error code. translog

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

hdbrestore set has been done both on application and database..however, i have reset the password for SYSTEM use well, still I am getting same error.

hdbsql -U DEFAULT

* 10: authentication failed SQLSTATE: 28000

[simon25]

Hi,

I fail to see how resetting the SYSTEM user password on HANA would interfere with the client user connection from ABAP.

What about the actual application user being used to connect with HANA from the client, are the user credentials for that user (e.g SAPABAP1) up to date and correct and stored for the user key pair in the hdbuserstore tool ?

Because these are just typical user+password errors:

4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 10 performing CON

4 ETW000 [ dblink ,00000] ***LOG BY0=>authentication failed

Check with the command 'hdbuserstore list' and the key used by the user. Update the password again for the user if required.

See hdbuserstore Commands

Test the connection afterward with 'R3Trans -d' and the result will get written to the 'trans.log' file.

Please also take a look at our FAQ on the topic which covers these type of scenarios : https://launchpad.support.sap.com/#/notes/2250144

Kind Regards

Simon