Why Doesn’t My Audit Track Anything

When you create a server audit, one of the things that might surprise you is that the audit doesn’t record data. So you create an audit for failed logins, as I did recently. You then login:

DisableAudit_01

Using a bad password will get you this:

DisableAudit_02

When you check the logs

DisableAudit_03

you see:

DisableAudit_04

What’s wrong? By default, when you create an audit, it isn’t enabled, so no data gets logged. You can enable it easily:

DisableAudit_05

And then when you have a failed login:

DisableAudit_02

You’ll find data in the logs:

DisableAudit_07

It’s a small detail, but one you want to keep in mind as you create audits. Be sure that they are enabled before you walk away from your production systems.

Unknown's avatar

About way0utwest

Editor, SQLServerCentral
This entry was posted in Uncategorized. Bookmark the permalink.