We're just rolling out SSRS in integrated mode with SharePoint Foundation 2010 and having issues trying to schedule and cache reports. The error we receive essentially says it cant do either of these because credentials are not stored.
From what Ive read, to do either of these, you need to configure the data source to either require no credentials (in which case the execution account is used) or enter the stored credentials to be used when the data source is accessed.
Our shared data source all the reports use are set to use is Windows authentication. Is it possible to use this data source but still have the ability to run scheduled and cached reports?
View Complete Post