I ran into a frustrating error the other day when I was preparing a demonstration machine for a TFS demo. The issue revolves around the report builder tool for SSRS and BI reporting, the issue occurred when I tried to preview a report I had built in Report Builder 2.0 (SQL Server 2008 R2). Basically when I tried to preview a report I received the following error:
“Failed to preview report: The permissions granted to user ‘account’ are insufficient for performing this operation. (rsAccessDenied)”
After checking the permissions settings in the reporting services and SQL (which were setup correctly), I did some googling and found that in order to preview the report in report builder I had to run the application as an administrator. To do this just right-click on the icon in your start menu and click on run as administrator.
