SQL server 2005 report server error

Posted on 2007-07-30
Last Modified: 2008-01-09
Hello, We are trying to setup reports in MS SQL 2005 Reports Services on Windows 2003. Initially we got the following error when browsing to http://computername/reports

The request failed with HTTP status 400: Bad Request.

We followed the following steps in the MS KB:

In the config file we put http://FQDN/reports

I dcan browse to a test file that i put in the reports virtual directory however when i browse to http://fqdn/reports, i get this:

The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version.

I can view http://FQDN/reportserver with no problems.

Thank you,
Question by:dolphan2013
    LVL 12

    Expert Comment

    It has problems contacting SQL instance.

    Check connection information in RSReportServer.Config ( Use rsconfig ( to store encripted connection information for report server.
    LVL 11

    Expert Comment

    by:Ved Prakash Agrawal
    Hi, Add the User role for browse report using report manager.

    Its better to provide the domain user for authetication and that user you can use in .net to access the report.

    if you have any ques let me knwo.


    Author Comment

    Thank you both but i am still having no luck.....the database and the report server piece both reside on the same machine....most of the settings are the named instance etc......

    I ran rsconfig but i get the same error.

    Shouldn't i at least be able to see the default reports page where you setup the data sources etc...when we first installed Reporting services we could view it.

    LVL 12

    Accepted Solution


    Author Comment

    Thanks Patrikt

    I had tried this earlier and it didnt work because i am an idiot :)

    I had put the url for the vd to reports not reportserver!

    Thanks again.......

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now