SSW Foursquare

DBAs - Do you turn on security auditing?

Last updated by SSW.Rules.SharePointExtractor almost 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

TurnOnSqlSecurityAuditing
Figure: Enable Auditing for SQL Server logins

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

Adam Cogan
SQL Databases - Admin
We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS