DBAs - Do you turn on security auditing?

Last updated by ChristianMWaite over 4 years ago.See history

Configure login security auditing:

  • Not on by default
  • Configure on the security tab of Server Properties in SQL Server Management Studio
  • Enable for Failure
  • View using the Windows Event Viewer

Figure: Enable Auditing for SQL Server logins

Note: You can turn on a trace for SQL DDL operations statements.

We open source. Powered by GitHub