SAP Knowledge Base Article - Preview

3075109 - change login's password fails with Msg 7742


  • set sp_passwordpolicy 'expire login passwords', 'login_name'
  • login's default database changed using alter login command
  • When the user logs into SAP ASE, the following message is raised:
     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.

    If user issues a simple query (e.g.) "select db_name()"  or "use master" the following message is raised.

    Msg 7742, Level 16, State 1:
    Server 'ASE_instance_Name', Line 1:
    You must change your password using the ALTER LOGIN command before you can continue.



SAP Adaptive Server Enterprise 16.0


SAP Adaptive Server Enterprise all versions ; SAP ERP 6.0


sp_password, alter login, ALTER LOGIN, Msg 7742, sp_passwordpolicy, expire login passwords, expire login, Msg 7992  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error

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.