DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 922656 - Last Review: July 28, 2006 - Revision: 1.2

Bug #: 426887 (SQLBUDT)

On This Page

SYMPTOMS

You can successfully open the report server site in Microsoft SQL Server 2005 Reporting Services. However, when you try to open the Report Manager tool, you receive one of the following error messages:
Error message 1
The request failed with HTTP status 400: Bad Request.
Error message 2
An attempt to connect to the report server failed. Check the connection information, and examine the compatibility with the current report server you are using.
This problem occurs when you assign an IP address that differs from the IP address of the local host (127.0.0.1) for the report server site.

CAUSE

This problem occurs because the Report Manager tool uses the incorrect server URL for the report server site. The URL of the report server site for which the Report Manager tool searches is specified in the ReportServerUrl tag in the file RSWebApplication.config file. By default, if you leave this tag blank, the Report Manager tool uses "Localhost" as the server URL.

WORKAROUND

To work around this problem, follow these steps:
  1. Open the file RSWebApplication.config file in a text editor. The RSWebApplication.config file is located in the following folder:
    SQLInstall\MSSQL.X\Reporting Services\ReportManager
    Note SQLInstall represents the location where SQL Server 2005 is installed. MSSQL.X represents the instance ID of SQL Server 2005 Report Services.
  2. Delete the entry in the ReportServerVirtualDirectory tag.

    Note You must not delete the ReportServerVirtualDirectory tag. Only remove the value of the ReportServerVirtualDirectory tag.
  3. In the ReportServerUrl tag, type a fully qualified URL to the report server. For example, use the following format:
    <ReportServerUrl>http://<FullyQualifiedURL>:<PortNumber>/<VirtualDirectoryOfReportServer></ReportServerUrl>
    <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
  4. Save the RSWebApplication.config file, and then close the text editor.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the problem

  1. Start Internet Services Manager.
  2. Expand Web Sites, right-click Default Web Site, and then click Properties.
  3. In the Properties dialog box, type a static IP address in the IP Address box.
  4. Click OK to close the Properties dialog box.
  5. Connect to the Report Manager tool.

APPLIES TO
  • Microsoft SQL Server 2005 Reporting Services
Keywords: 
kbsql2005rs kbexpertiseadvanced kbtshoot kbprb KB922656
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support