Password expired.ERRORCODE=4214,

[former_member201054]

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

[Former Member · Accepted solution]

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

[former_member201054 · Accepted solution]

The error says password expired for db2

so want to know which db user and how can we renew the password at OS level

I appreciate your help

Thanks a ton

[former_member201054 · Accepted solution]

any update/help?

Thanks a ton

[Former Member · Accepted solution]

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.

[v_veeramalla]

Hi

You can use

To change the password of the ABAP database connect user (sapr3 or sap<sapsid>), use program dscdb6up

refer the link- http://help.sap.com/saphelp_nw70/helpdata/en/aa/1dc8d8f0fa11d3a6510000e835363f/content.htm