Unable to Preview a Report in Report Builder: rsAccessDenied

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.

Leave a comment

Website Built with WordPress.com.

Up ↑