SAP Knowledge Base Article - Preview

2512984 - The Current Failed login attempts is not updated - ASE


  • The ASE Configuration parameter 'net password encryption reqd' is enabled (non-zero) indicating that passwords must be encrypted
  • The isql utility provides the parameter -X  to request password encryption
  • An isql client attempts to logon, supplies a valid password but does not use include the parameter -X
  • The server rejects the login attempt
  • sp_displaylogin shows the counter (stored in syslogins.logincount) has not incremented

isql -Utest -Pabc123
Msg 1640, Level 16, State 2:
Server 'test':
Adaptive Server requires encryption of the login password on the network.
Msg 4002, Level 14, State 1:
Server 'test':
Login failed.
        ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

1> sp_displaylogin test
2> go
Suid: 4
Loginame: test
Default Database: master
Default Language:
Auto Login Script:
Configured Authorization:
Locked: NO
Date of Last Password Change: Jul 17 2017 10:27AM
Password expiration interval: 0
Password expired: NO
Minimum password length: 6
Maximum failed logins: 4
Current failed login attempts: 0
Authenticate with: AUTH_DEFAULT
Login Password Encryption: SHA-256
Last login date: Jul 31 2017 11:41AM
Exempt inactive lock: 0



SAP Adaptive Server Enterprise (ASE) All Releases


SAP Adaptive Server Enterprise 15.7


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.