Tuesday, May 5, 2009

Microsoft.ReportingServices.RsProxy.AccessDeniedException

I Came across this error message (Exception of type 'Microsoft.ReportingServices.RsProxy.AccessDeniedException' was thrown. ) today whilst installing SQL Server 2005 Reporting Services on a windows 2003 server

thought i'd share the answer for anybody else search as there wasn't much on the Internet for it.

To fix the issue I followed these steps :-

Go to Report Manager
Select Site Settings from the top right menu
Select Configure item-level role definitions
Select Content Manager
make sure all the tick boxes are ticked
For myself the Manage / View models tickboxes were not ticked and this fixed the issue

Hope this helps you out.

No comments: