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
Hello
Did you get a resolution to this problem?
We have found that the TessituraSSRSProxy under ASP.NET v4 doesn't work correctly (producing 404 errors), and so we are running it on ASP.NET v2.
Are there other specific IIS 7 settings that needs to be tweaked, such as running it in Integrated versus Classic mode?
Hey David Im in a very similar boat
As you may already know The default install of SSRS 2008 does not use IIS. (unlike SSRS 2005 IIS is not needed in SSRS 2008). This is one of the issues I’ve been dealing with as well. IIS is needed in order for the tessitura proxy server to work
It took me a while to figure this out and I’m still working on installing SSRS 2008 with IIS in our test environments. (we still use SSRS 2005 in our production environment) To my knowledge tessitura does not have documentation on how to set up a proxy server with SSRS 2008. After talking with AIM they said it should be very similar to 2005. I plan on trying the install later on this week. im very interested in your solution.
Best of Luck
Jason
Unknown said: As you may already know The default install of SSRS 2008 does not use IIS.[...] To my knowledge tessitura does not have documentation on how to set up a proxy server with SSRS 2008.
You are correct, this is a documentation gap that will hopefully be filled ASAP.I stumbled through it, eventually getting IIS to work for me on Server 08 and SSRS08R2. The new IIS Manager is drastically different (not always helpfully so).
In case it's helpful to someone: one thing I recall being crucial and non-obvious was that the TessituraSSRSProxy needed to be in the Classic .NET App Pool under ASP -> Basic Settings.
Hey Chris,
Im still working on trying to set up SSRS 2008 in our test environment. Have you had any luck with this
Unknown said: Im still working on trying to set up SSRS 2008 in our test environment. Have you had any luck with this
Yep, we're all done here. What are you running into?
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
Unknown said: Im basically stuck on how and where to integrate IIS in the SSRS set up.
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).
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:
From: Jason Minnis <bounce-jasonminnis5841@tessituranetwork.com>Sent: 4/12/2011 12:42:20 PM
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!
Seems like we are in opposite sides of the spectrum. I dident have much of a problem migrating our report server database from 2005 to 2008. The SSRS proxy set up has been the issue over here. I tried setting up the SSRS proxy server as its own website and I still havent had any luck. :) i keep getting the error below
-------------------------
Error An error occurred during the automatic redirect. Error: Report type must be SSRS Post (5)
-----------------------------------
The error message you are getting is coming from the DB procedure that gathers the request data for the report request.
1. Are you attempting to use a Report set with a report type of SSRS URL through the proxy? The type needs to be SSRS Post (as the error indicates).
2. Check the web.config for the SSRS Proxy. Is it pointing to the correct database?
a. I’ve seen a few instances where the proxy was pointed at TEST while they were pointing to the proxy in LIVE. The request IDs would be out of sync and may generate this error.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason MinnisSent: Thursday, April 14, 2011 2:46 PMTo: Ryan CrepsSubject: Re: [Tessitura Technical Forum] SSRS Setup Woes
ErrorAn error occurred during the automatic redirect.Error:Report type must be SSRS Post (5)
From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>Sent: 4/12/2011 12:57:31 PM