Use sp_configure parameters to specify whether Adaptive Server writes
auditing events, such as logins, to the Adaptive Server error log.
By default, Adaptive Server does not log auditing events. To log events, you can use
sp_configure with these possible parameters and values:
log audit logon success at 1 – to
enable logging of successful Adaptive Server logins:
sp_configure "log audit logon success", 1
log audit logon failure at 1 – to
enable logging of unsuccessful Adaptive Server logins:
sp_configure "log audit logon failure", 1
Either parameter at 0 – to disable logging
of that message type:
sp_configure "log audit logon success", 0
sp_configure "log audit logon failure", 0
See the System Administration Guide: Volume 1.