I'm currently setting up a SharePoint Foundation Farm with a front-end server hosting central administration (which we'll refer to as spfrontend) and a Sql Server with SSRS in SharePoint Integrated mode (which we'll refer to as ssrsserver). I can run SSRS reports uploaded to my SharePoint Site by navigating to the report through http://ssrsserver/ReportServer interface, and the reports render as expected. However, when I try to access it though the http://spfrontend/MySite interface, regardless of accessing it as a webpart on a webpart page, or clicking on the link directly, it always returns an error similar to the following:
Execution 'mofg0y450k5icx55iz1z31bj' cannot be found (rsExecutionNotFound)
Neither of the application logs on the ssrsserver or the spfrontend machines are reporting any special errors. How can I get the spfrontend server to correctly display my reports?