Ok. it has been a long day... I am trying to move my SSRS server, a Windows 2008 R2 server. I have setup the SSRS Proxy (I think) and installed Reporting Services. I can Deploy reports to the server. I have changed the T_Defaults settings. However, when I run the reports in Tessitura, I get a screen with a Server Error - 404 error.
Any ideas?
David
Apart from the differences between IIS 6 and IIS7 (or 7.5), there is essentially NO difference in the setup process for the TessituraSSRSProxy between SSRS 2005 and SSRS 2008. In 2008, the SSRS WebServices are no longer virtual directories in IIS, they are served over HTTP.SYS. The TessituraSSRSProxy remains a web application hosted in IIS. In IIS7+, you need to go through the additional step of making the virtual directory a web application (which can be done after the fact by right clicking on the directory in IIS and selecting “Convert to Web Application”).
In v10.0, as for the app pool, it should be running under the ‘Classic .NET App Pool’ (created by default) or under any application using a Managed Pipeline of “Classic” and .NET Framework version 2.0.
Keep in mind also that you don’t need to necessarily host the TessituraSSRSProxy on the database server running IIS. This could easily be loaded onto your gateway server, using a website designated for intranet traffic.
Hope that clears things up a bit here. We are in the works of producing a series of T-Casts to help with the SSRS 2008 transition. Sadly they’ve been a bit held up in production.
-Ryan Creps
Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris JensenSent: Tuesday, April 12, 2011 2:00 PMTo: Ryan CrepsSubject: Re: [Tessitura Technical Forum] SSRS Setup Woes
Jason Minnis:Im basically stuck on how and where to integrate IIS in the SSRS set up.
Jason Minnis:
Im basically stuck on how and where to integrate IIS in the SSRS set up.
I think running through the Reporting Services Configuration Manager as usual, plus basically setting up the SSRSProxy as it was under SSRS05 (or as closely as the radically different IIS7 UI would let me), did it for us for the most part. I did run into the app pool issue I mention above.
Getting SSRS<>IIS to work here was no big deal compared to trying to get our existing SSRS05 ReportServer db to update, open and function properly under SSRS08R2 on a different system. In the end I gave up on that and just redeployed our existing reports to new projects and the new db (we were moving from one VM server to another rather than upgrading a server).
From: Jason Minnis <bounce-jasonminnis5841@tessituranetwork.com>Sent: 4/12/2011 12:42:20 PM
Hey Chris
Im basically stuck on how and where to integrate IIS in the SSRS set up. When i go to our report server url (tessi-rs-test/Reportserver) i am able to browse to the reports with no problems. Im just stuck on how to intergrate IIS with SSRS 2008 (and use the proxy server)
In our SSRS 2005 environment we have applications sites running under our default website
Tessitura Production Reports (which points to the Reports Admin site)
TessituraProductionReportServer( Which points to the Report directories
Tessiutra SSRS proxy (which runs the proxy server, this link is used In the client to redirect
IN 2008 I set up the SSRS proxy server as a website. When I try to run the reports I get the following error
An update I tried running the proxy server as a website and i still got the following error when I went to run the report.
An error occurred during the automatic redirect.
Error:
Report type must be SSRS Post (5)
Tessitura
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!