x

Need to correct SSRS 2005

Some time ago we moved our production databsase from an older server to a new one. At the time I made a mistake, in copying all of our SQL Server Reporting Services reports, to the new server. I just copied them, and thought that was all I had to do. It's been too long, and so I don't remember exactly what it is I did, but now it just looks awful. For example, when going to the website: http:///ReportServer I get a directory listing of all of the SSRS reports, instead of the web application mention that's normally available using SSRS. So far, we've not had the time to fix this, but I've got a little time on my hands now and so would like to address this. How do I fix this problem?

more ▼

asked Dec 02, 2010 at 09:20 AM in Default

avatar image

Rod
801 48 51 55

Did you try to navigate to http://your_server/Reports? This should give you SSRS home page where you can configure your report files (place them in the folders, manage permissions etc).

Dec 02, 2010 at 09:47 AM Oleg
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

As @Oleg wrote in comment the http:///ReportServer is by default a SSRS Web service virtual directory..

The report manager what you are probably looking for is by default in http:///Reports.

If you want to know exactly the correct URL for the manger, run the Reporting Services Configuration Manager ns inside you will find exact ULRs for the manager and also for web service.

more ▼

answered Dec 02, 2010 at 10:26 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

Thank you, @Oleg, for your help. I've gotten into the Reporting Services Configuration manager on the server. It says the Report Server Virtual Directory is named ReportServer and the website is, "Default Web Site". So I get into IIS on the server and took a look. There's a Reports website and a ReportServer website under the Default Web Site. If I go to the ReportServer website on that server (http:///ReportServer), then I get what I mentioned above - just a directory listing. If I go to the Reports website (http:///Reports), then I get the following error message:

"Unable to connect to the remote server"

and a link to the Home page, which takes me back to the same page.

So, I've done something wrong, or failed to complete something. What is that?

Dec 03, 2010 at 10:23 AM Rod

Seems, there is something wrong with IIS virtual direcotry binding or the SSRS configuration.. Try to reapply (reconfigure) the Repor Manager URL (Virtual directory) in the Reporting Services Cofiguration Manager. This could fix the problems.

Dec 03, 2010 at 11:05 AM Pavel Pawlowski

@Rod I am afraid that it has something to do with your report copying. The key is to figure out what do you mean by saying that you copied ald reports to your new server? Default page of the Reports virtual directory is Home.aspx. When you navigate to it using either IIS Manager (right-click on Home.aspx and choose browse) or by using IE and typing respective URL, it tries to enumerate through existing reports and display them as links. At some point it thinks that it needs to connect to the old server and it cannot.

I am sure Pavel will know how to deal with this problem when he will read this comment and come back. In a mean time, have a look at the Reporting Services Scripter written by Jasper Smith. He originally wrote it for SSRS 2000 but then updated it last year to also work with SSRS 2005 and 2008.

Dec 03, 2010 at 11:06 AM Oleg

As I wrote, the Reporting Services Configuration manager can fix the problems. Eventually delete the virtual directory in IIS and recofigure it back from the manger.

Anyway the Reporting Services Scripter is a good tool to script out all the reports for moving to other server.

But if you need to move all the reports to new server, you can simply make a backup of the Report Server database, restore it on a new server and then in the configuration manager specify thet the new report server should use the restored DB. But do not forget to backup the encryption key on the original server and then restore it on the new server. In this case you will have access also to all datasources and even new server will be able to use stored passwords in the datasources. If you do not backup/restore the key, you will have to delete all the encrypted data.

Moving the DB in such way is much better if you wat to move all the reports.

Dec 03, 2010 at 11:21 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left

I think Oleg is Right on with the answer above

more ▼

answered Dec 02, 2010 at 10:28 AM

avatar image

Clint
100 6 6 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2034
x709

asked: Dec 02, 2010 at 09:20 AM

Seen: 1154 times

Last Updated: Dec 02, 2010 at 09:20 AM

Copyright 2018 Redgate Software. Privacy Policy