CHAPTER 11 SECURING REPORTS
Figure 11-23. Report Execution Audit reportIntroducing Log File Auditing
In addition to report auditing, SSRS supports two other types of logging: standard Windows event
logging and trace file logging. You can use both of these resources to search for errors and warnings, as
well as for other important information such as security information.
All of the trace files are stored in the default installation location Drive:\Program Files\ Microsoft
SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles. Several types of log files exist:
ReportServerService and ReportServer. Each file is named with a timestamp, such as
ReportServerService_05_31_2012_17_00_30.log and
ReportServerService_HTTP_05_31_2012_17_00_30.log, and contains information specific to its
individual service. You can gather five levels of trace log information— 0 through 4—that are controlled
in the ReportingServicesService.exe.config file in the Reporting Services\ReportServer\Bin folder.
Selecting 0 will disable tracing, and selecting 4 will enable verbose mode. Whenever an issue arises with
SSRS, the administrator can generally isolate the problem by looking in either the event log or one of the
trace files.