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 for Me (Login required).

Search for additional results

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