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