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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.