You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains ten Microsoft SQL Server 2005 servers which you administer. MiracleInfocom .com management has recently decided to tighten network security. A new MiracleInfocom .com security policy requires that only network users with security clearance can manage security principals and roles. You additionally need to audit the users who are currently making such changes on the database servers whilst your solution does not impact performance more than required. What should you do?
A. Enable object access event auditing in Audit Policy.
B. Enable auditing for account management events in Audit Policy.
C. C2 audit mode for the SQL Server instance must be enabled.
D. A SQL Server Profiler trace should be created.
Answer:D
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains ten Microsoft SQL Server 2005 servers which you administer. MiracleInfocom .com management has recently decided to tighten network security. A new MiracleInfocom .com security policy requires that only network users with security clearance can manage security principals and roles. You additionally need to audit the users who are currently making such changes on the database servers whilst your solution does not impact performance more than required. What should you do?
A. Enable object access event auditing in Audit Policy. B. Enable auditing for account management events in Audit Policy. C. C2 audit mode for the SQL Server instance must be enabled. D. A SQL Server Profiler trace should be created.