By default, the Cluster Edition does not log auditing events. However, you can use sp_configure parameters to specify whether the Cluster Edition is to log auditing events, such as logins, to the Cluster Edition error log.
Possible parameters and values are:
log audit logon success at 1 – to enable logging of successful Cluster Edition logins:
sp_configure "log audit logon success", 1
log audit logon failure at 1 – to enable logging of unsuccessful Cluster Edition 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: Volume 1.
