By default, Adaptive Server does not log auditing events. However, you can use sp_configure parameters to specify whether Adaptive Server is to log auditing events, such as logins, to the Adaptive Server Error Log.
Possible parameters and values are:
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
For more information about sp_configure, see the System Administration Guide.
