• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

SQL server 2005 report server error

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:

http://support.microsoft.com/kb/922656

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,
0
dolphan2013
Asked:
dolphan2013
  • 2
  • 2
1 Solution
 
patriktCommented:
It has problems contacting SQL instance.

Check connection information in RSReportServer.Config (http://msdn2.microsoft.com/en-us/library/ms157273.aspx). Use rsconfig (http://msdn2.microsoft.com/en-us/library/ms162837.aspx) to store encripted connection information for report server.
0
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
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.
:)

0
 
dolphan2013Author Commented:
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 default.....no 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.

0
 
patriktCommented:
0
 
dolphan2013Author Commented:
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.......
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now