DBAs - Do you turn on security auditing?
Updated by ChristianMWaite 5 years ago. See history
123
<introEmbed
body={<>
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.
Categories
Acknowledgements
Related rules
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.