October 2010
Intermediate to advanced
1008 pages
46h 16m
English
Enabling security auditing on SQL Server will monitor and track activity to log files that can be viewed through Windows application logs or SQL Server Management Studio. SQL Server offers four security levels with regards to security auditing, as follows:
• None— Disables auditing so no events are logged.
• Successful Logins Only— Audits all successful login attempts.
• Failed Logins Only— Audits all failed login attempts.
• Both Failed and Successful Logins— Audits all login attempts.
Security auditing is set to Failed Logins Only by default. It is a best practice to configure security auditing to capture both failed and successful logins. At the very least, security auditing should be set to Failed Logins Only. ...
Read now
Unlock full access