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.
Note
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.
Troubleshooting URL Reservations in HTTP.sys
The following table describes the tools available to configure and troubleshoot HTTP.sys.
Tool |
Description |
Resources |
|---|---|---|
Httpcfg.exe |
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 |
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 Logging |
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. .gif "Note") Note
HTTP.sys logging is not enabled by default.
|
Troubleshooting HTTP Errors in SQL Server Books Online |
Troubleshooting SQL Server Reporting Services
The following table describes the tools available to troubleshoot Reporting Services.
Tool |
Description |
Resources |
|---|---|---|
Kerberos Logging |
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 |
Perfmon.exe |
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 |