497
Chapter 19: Confi guring SQL Server
19
FIGURE 19-8
Security tab of Management Studio’s SQL Server Properties dialog.Security-Audit Level
The login auditing options confi gure the level of user-login auditing performed by SQL Server.
You can choose one of the following four login auditing options (refer to Figure 19-8):■ (^) None
■ Failed logins only
■ (^) Successful logins only
■ Both failed and successful logins
Based on the setting, SQL Server records every successful or failed user login attempt to
the Windows application log and the SQL Server log. SQL Server service must be restarted
for the login auditing options to take effect.
C2 Audit Tracing
C2 auditing is a U.S. government standard for monitoring database security. SQL Server
supports C2 auditing. To confi gure SQL Server for C2 auditing, enable the c2 audit mode
c19.indd 497c19.indd 497 7/30/2012 5:42:58 PM7/30/2012 5:42:58 PM
http://www.it-ebooks.info