Team System Developer Center > SQL Server Forums > SQL Server Reporting Services > SQL reporting Server(The request failed with HTTP status 400: Bad Request)
Ask a questionAsk a question
 

AnswerSQL reporting Server(The request failed with HTTP status 400: Bad Request)

  • Thursday, November 05, 2009 11:41 PMSeansArcher Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Hi,

    After configuring a report server on SQL 2005 machine I get the following message when trying to acess:  http://localhost/reports
    The request failed with HTTP status 400: Bad Request.

    a user name and password window pops up and regardless of what I put there I get the same message.
    • Moved byRuiz Yi Monday, November 09, 2009 8:54 AMAbout Reporting Service (From:Team Foundation Server - Reporting & Warehouse)
    •  

Answers

  • Tuesday, November 10, 2009 7:06 AMJin ChenMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi SeansArcher,

    Based on our experience, the issue is caused by the invalid configuration in the RSWebApplication.config.

    Please follow these steps to solve the issue:
    1.Open the RSWebApplication.config with notepad.
    2.Remove the value in the element ReportServerurl
    3.Save the file.
    4.Open Internet Information Server(IIS) manager, changed specific IP address to "all unassigned".
    5.Then restart Internet Information Server(IIS) by running the command "iisreset"

    Now, we should be able to view the report server and the report manager.

    Please feel free to ask, if you have any more questions.

    Thanks,
    Jin Chen


    Jin Chen - MSFT

All Replies

  • Monday, November 09, 2009 8:55 AMRuiz Yi Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi,

    I am moving this thread to Reporting Service forum, and there will be more members that will help you .

    Best Regards,
    Ruiz
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi
  • Tuesday, November 10, 2009 4:47 AMRama Raman-MSFTMSFTUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Are you able to access the reportserver URL http://localhost/reportserver?

    What is the authentication mode that you are using? Are you using Kerberos?

    Thanks,
    Rama - MSFT
  • Tuesday, November 10, 2009 7:06 AMJin ChenMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi SeansArcher,

    Based on our experience, the issue is caused by the invalid configuration in the RSWebApplication.config.

    Please follow these steps to solve the issue:
    1.Open the RSWebApplication.config with notepad.
    2.Remove the value in the element ReportServerurl
    3.Save the file.
    4.Open Internet Information Server(IIS) manager, changed specific IP address to "all unassigned".
    5.Then restart Internet Information Server(IIS) by running the command "iisreset"

    Now, we should be able to view the report server and the report manager.

    Please feel free to ask, if you have any more questions.

    Thanks,
    Jin Chen


    Jin Chen - MSFT