Login to Sybase Adaptive Server fails with "4002 (Login failed.)" error

book

Article ID: 35067

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Symptoms


Connection test to Sybase Adaptive Server failed with "This routine cannot be called since an asynchronous operation is currently pending." error, and "sybase: Message String: Login failed." message was logged in sybase.log.





Solution


Sybase Adaptive Server does not provide any detailed information if user failed to login, because of preventing malicious attacks. So, using Auditing function on Sybase Adaptive Server is required for confirming the cause of the login failure.

Reference Information:

Adaptive Server Enterprise 15.0 > System Administration Guide: Volume 1 > Auditing > Understanding the audit tables

http://infocenter.sybase.com/archive/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1867.htm

Auditing login failures

Although client applications may fail to login for many reasons, Adaptive Server does not provide them with any detailed information about the login failure. This is done to avoid giving information to malintentioned users attempting to crack passwords or otherwise breach Adaptive Server?s authentication mechanisms.

?

Environment

Release:
Component: UIMSYB