Dela via

  • Artikel

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.

NoteNote
HTTP.sys logging is not enabled by default.

Troubleshooting HTTP Errors in SQL Server Books Online

Error Logging in the HTTP Server API on MSDN

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:

  • MSRS 2008 Web Service

  • MSRS 2008 Windows Service

  • ReportServer:HTTP

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:

  • Report Server Execution Log

  • Report Server Service Trace Log

  • Report Server HTTP Log

  • Windows Application Log

  • Windows Performance logs

  • Setup log files

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