Troubleshooting SQL Server Reporting Services

After the installation and configuration of SQL Server Reporting Services (SSRS), it is generally trouble-free. Sometimes, you must check and diagnose the correct issues that can occur. There are two areas where you have to investigate issues within SSRS. These are logfiles and event error logs.

SSRS uses a great number of logfiles, which are native to SSRS and some are generated with the interaction with Configuration Manager:

• SQL Server's report server log files: You can find more information on these files at http://msdn.microsoft.com/en-us/library/ms157403.aspx

• Report server service trace log: These files are created daily and contain detailed information

• Report server execution log: This is a diagnostic log that you can enable in the reporting site settings

• Report server HTTP log: This is a diagnostic log that can be enabled by modifying the ReportServerService.exe configuration file

• Srsrpsetup.log: This is a Configuration Manager SSRS reporting...