SSW Foursquare

DBAs - Do you turn on security auditing?

Last updated by ChristianMWaite about 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. Powered by GitHub