Troubleshooting Tools (Reporting Services)
This topic describes the tools available to troubleshoot SQL Server 2008 Reporting Services. These tools can be divided into two areas: tools available for troubleshooting the Hypertext Transfer Protocol (HTTP) Server API, HTTP.sys, and tools available for troubleshooting Reporting Services. You might need to use these tools when you need more information about reserved Uniform Resource Locators (URLs) for the Reporting Server or when you don't see values that you expect or understand in the Reporting Services Configuration tool.
Beginning with SQL Server 2008, you might need to troubleshoot problems with HTTP.sys, because Reporting Services uses HTTP.sys to reserve URLs. Previous versions of Reporting Services used Internet Information Services (IIS) to do this. For more information about HTTP.sys, see HTTP Server API on MSDN.
The following table describes the tools available to configure and troubleshoot HTTP.sys.
Httpcfg.exe is a configuration tool available in Windows Server 2003. Use Httpcfg.exe to verify namespace reservations in HTTP.sys.
Httpcfg.exe on MSDN
Httpcfg Syntax on TechNet
Netsh.exe is a configuration tool available in Windows Vista and Windows Server 2008. Use Httpcfg.exe to verify namespace reservations in HTTP.sys.
Netsh Commands for Wired Local Area Network (lan) on Microsoft TechNet
HTTP.sys Manageability in Windows Vista and Windows Server 2008 on the Microsoft Download Center
New Networking Features in Windows Server 2008 and Windows Vista on Microsoft TechNet
HTTP.sys records error information in the HTTP.sys log file. Use this information to troubleshoot problems related to URL reservations or HTTP errors, such as bad requests, access problems, and service availability.
HTTP.sys logging is not enabled by default.
Troubleshooting HTTP Errors in SQL Server Books Online
The following table describes the tools available to troubleshoot Reporting Services.
Windows operating systems can be configured to log Kerberos events in the system and security event logs. Use information in these events to troubleshoot issues related to Kerberos authentication.
How to enable Kerberos event logging in Help and Support
Windows operating systems can be configured to log events in the Application event log. Use performance monitor to add the following Reporting Services performance counters:
Performance and Reliability in the Windows Server 2008 Technical Library
Perfmon in the Windows Server 2003 Technical Library
Reporting Services Logging
Reporting Services records information in a variety of log files. Use the following log files to discover information about server operations and report server applications that run on the local computer:
Reporting Services Log Files in SQL Server Books Online
Errors and Events Reference (Reporting Services) in SQL Server Books Online
Windows Application Log in SQL Server Books Online