Recently we had a problem with report subscriptions not working with Reporting Services. Like most problems, this is compounded with the usage of several technologies and methodologies. In our case:
- SQL Server Reporting Services 2008
- SharePoint Integrated Mode
- Forms Based Authentication
Everything was working, except a strange error message when setting up subscriptions to reports. The error message in SharePoint, as well as the Reporting Services log was:
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘fba:firstname.lastname@example.org’ are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘fba:email@example.com’ are insufficient for performing this operation.
Of course, the email address has been changed above to limit the spam factor. But what’s curious is that SSRS was whining about an FBA user not having rights to run the report. Incidentally, not only *can* this user account run reports, but it is also a Site Collection admin. Holy Grand Puba Batman.
Dug around a bit, and it seems it *is* a permissions issue, but the red herring is pointing you to the FBA user. That’s not it. The issue is the service account (the one we rely on the execute this unattended subscription on our behalf) not having access to SharePoint.
Open Reporting Services Configuration Manager and check the Service Account menu. The account being used for the Reporting Services service startup MUST be in your SharePoint site.
If your service account is ‘Local System’, then in SharePoint, add the user NT AUTHORITY\SYSTEM.