Symptom
- User passwords expire immediately after setting 'password expiration' at the server level and on connection message 4022 is returned:
Msg 4022, Level 10, State 1:
The password has expired, but you are still allowed to log in. You must change your password before you can continue. If a login trigger is set, it will not be executed.
- Is there a way to do this so they expire on the next interval and not immediately?
- Need to make the password valid again without resetting the password
- In a HADR environment, the following error may be seen in the RMA log:
Attempting to authenticate a session with a 'DBSERVER' connection to a 'ASE' as user 'DR_admin' on host and
getConnection: 01ZZZ: Password has expired Please set the NEWPASSWORD property with the new password or use sp_password to change passwords." in RMA log.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) All Versions
Product
Keywords
expiration, reset, password, sap_host_available, DR_maint, Password has expired, Msg 4022 , CR 830306 , 830306 , CR#830306
syslogins , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview