asked
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?
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.
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.
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?
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.
@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][1] 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. [1]:
http://www.sqldbatips.com/showarticle.asp?ID=62
I think Oleg is Right on with the answer above
