The SQL Server Knowledge Pack expands the auditing and reporting capabilities of InTrust to SQL Server. It lets you gather events from the SQL Server C2 log, the Error log and replication agent history, and make reports on these events.
The Knowledge Pack is compatible with the following versions of Microsoft SQL Server Reporting Services:
To gather the C2 log and the Error log with InTrust for reporting, configure SQL Server audit as described in the related topics:
C2 logging is the more comprehensive of the two logging options in SQL Server. However, it is also more resource-intensive than Error log writing, and it is turned off by default. If C2 logging is disabled on your SQL servers for performance reasons, then you can only audit events from the Error log.
If you need to collect more information than the Error log can provide, then enable C2 logging for your SQL servers.
To enable C2 logging
To successfully turn on C2 logging, you must a member of the sysadmin role.
To ensure correct operation when gathering C2 logs from several SQL servers
Unlike the C2 log, the Error log is always enabled.
To prepare the SQL Server Error log for gathering