SAP Knowledge Base Article - Preview

2858698 - User sapsa locked again after manual unlock - SAP ASE for Business Suite


  • You noticed that the user sapsa keeps getting locked after you have manually unlocked it, returning error "Login failed" (user password is well defined). 
  • From the "sp_displaylogin sapsa" output you can see something similar to those lines:

isql -S<SID> -Usapsso -X 

1> sp_displaylogin sapsa
2> go
Suid: 4
Loginname: sapsa
Locked: YES
             Date when locked: MMM DD AAAA hh:mm[am|pm]
             Reason: Accound locked by ASE due to failed login attemps reaching max filed logins
Maximum failed logins: 7
Current failed login attempts: 7 



  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0 ; SAP ERP 6.0 ; SAP NetWeaver 7.5 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Supplier Relationship Management 7.0 ; SAP Supply Chain Management 7.0


KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.