Windows authentication and scheduling / caching reports
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?
October 11th, 2010 11:21pm
There can be a whole bunch of settings to tweak when Reporting Services is set up in Sharepoint mode. Following might help:- http://msdn.microsoft.com/en-us/library/ee384252(SQL.100).aspx Cheers!! Muqadder.
October 12th, 2010 12:59am
No. You must use stored credentials. Think about it, it makes sense that the credentials must be stored with cached reports. Russel Loski, MCT
October 12th, 2010 1:02am
That page has no mention of what Im trying to do. Im not really looking to troubleshoot anything. Im looking to find out how users schedule /cache SRS reports that are normally set to use Windows authentication.
October 12th, 2010 1:05am
No. You must use stored credentials. Think about it, it makes sense that the credentials must be stored with cached reports. Russel Loski, MCT While that certainly makes sense, when users are accessing the reports real-time we need to make sure Windows credentials are used as the data results vary significantly based on whos running the report. What I was hoping would be possible is to simply use the execution account (or some other functionality) to run scheduled reports as, but still run "real-time" reports as the user thats actually running them. I find it extremely hard to believe that this wouldnt be a very common request that someone would have in using SRS.
October 12th, 2010 4:12am
Hi timofcourse, In the current reporting services, stored credentials are used if the report runs unaatended. The report server retrieves and uses the credentials when report processing is scheduled or triggered by an event rather than a user request. If you have any concern about this, please submit a feedback at https://connect.microsoft.com/SQLServer/Feedback and hope microsoft enhance this ability in the next release. thanks, Jerry
October 13th, 2010 10:31am
So how are people using reports traditionally now when it comes to scheduling and authentication? Do most not have a need for using Windows credentials to run reports? Or is it they have two copies of the report - 1 configured with a data source that uses Windows auth and one that uses stored credentials thats used exclusively for scheduling the report? Or is it just simply not that common that reports that traditionally use Windows authentication would not need to be scheduled because you wouldn't want to run it as a single, specific user? Thanks!
October 13th, 2010 4:42pm