I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list. Reporting services seems to work fine setup in SharePoint 2010 Integrated mode.
When I try and run a report that is based on a sharepoint list, I immediatly get the following error:
The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound)
This seems to be something I am doing wrong with the sharepoint configuration, I would guess. I haven't tried a regular database query, but they used to work when reporting services was configured for native mode. So I assume this is just a problem
connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type.
Edit This has got to have something to do with a permission setting for the app pool account of sharepoint. I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention
anything about it.
This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account.
library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, tim
View Complete Post