Hello

Did you get a resolution to this problem?

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.

  Error

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.

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).

Hey Chris

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)

-----------------------------------