All,
We're getting lots of reporting services problems with our new site :(
We have a single reporting services box serving reports to 2 web servers. We run app pools on the web servers under NETWORK SERVICE. We've granted the machinename$ account permissions on the reporting services box.
Although we are meant to have session affinity on our load balancer we are getting problems where the report server caches a report for App1$ but is then asked get the cached report for App2$. This then falls over with a "The report execution xxxxxx has expired or cannot be found. (rsExecutionNotFound)", although the cached report does exist but under the owner of App1$.
My question is should we change the app pools so they run under an Active Directory account? Therefore they will submit requests to the report server with the same owner.... or is this just bad practice?
Could something else be going on instead? We're investigating the session affinity on the load balancer to see if that is configured incorrectly.
