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 and to the NT event 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.
