Hi,

The below error comes in default trace and not able to connect the system

connection authorization failure occured. Reason : Password expired.ERRORCODE=4214, SQLSTATE=28000'.

#6#-4214#28000# connection authorization failure occurred.Reason :password expired. ERRORCODE=4214,SQLSTATE=28000#jdbc:db2://siddb:7912

what db2 userid got expired and how can it be renewed at OS level..

OS is SUSE linux...pls give the command also for solving the problem

I appreaciate your help

Thanks a ton

Hello,

You need to set the password on OS level on the db server (in the user menagement of the OS)

To synch the password used by the java stack for sap<sid>db, you have to

set it in the config tool -> secure store informations.

jdbc/pool/<SID>_REMOTE/User

jdbc/pool/<SID>_REMOTE/Password

See SAP note 997510 for further details.

Regards,

Paul

Is this your production server?

DB2 user password change is not easy even if you find out the os user id.

Cannot connect from configtool unless you have working user id and password.

So, if it is not a production server, un-expire all user password from OS

The password policy from OS make it expired.

IAS Admins with only reset password access in IAS admin console in Technology Q&A 2 hours ago SAP Enable Now/Companion Server Certificate Renewal from Basis End #ATR in Technology Blogs by Members Friday How to Import Data from DataBricks Spark on AWS to SAP Analytics Cloud in Technology Blogs by SAP Wednesday Part 1 - Prerequisites and Setup Instructions for Datasphere BW/4HANA Model Transfer in Technology Blogs by SAP Tuesday Prerequisites and Setup Instructions for Datasphere BW/4HANA Model Transfer in Technology Blogs by SAP Tuesday