Skip to Content

Password expired.ERRORCODE=4214,

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 10:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Daniel basis

      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.

  • Posted on May 12, 2011 at 07:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.