SAP Knowledge Base Article - Preview

2869159 - Login failed message may be logged in errorlog by ODBC Test Connection - SDK for SAP ASE

Symptom

  • The following ASE configuration parameters are set to 1.

log audit logon success = 1
log audit logon failure = 1

  • You start ODBC Administrator and open a data source, and then click "Test Connection" button. A popup window appears and you enter a correct password and click "OK", then login attempt is successful.
  • Even if Test Connection succeeds, you may notice the following messages in ASE errorlog.

Logon  Login failed : User xxx, Client IP address: 'xx.xx.xx.xx', Appname: odbcad32.exe, Progname: ODBC, Progversion: xx.x.x.xx, TdsVersion:5.0.0.0.
Logon  Login succeeded : User xxx, Client IP address: 'xx.xx.xx.xx', Appname: odbcad32.exe, Progname: ODBC, Progversion: xx.x.x.xx, TdsVersion:5.0.0.0.

  • If you configure sybsecurity database and audting and set login failure audit option, you may see audit records about login failure.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • Adaptive Server Enterprise ODBC Driver by Sybase

Keywords

sybsecurity, sp_audit, sybdrvodb.dll,  sybdrvodb64.dll, sybdrvodb , KBA , BC-SYB-SDK , SDK , 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.