rsaccessdenied

You need to assign a role for your users on the Report Server.  Log into the Report Manager (http://servername/Reports or http://servername/Reports_instance if you use an SQL instance name), click on the Folder properties under the Home folder (the home page).  From there, you can assign the role of “Browser” to “Domain/Users”.  You can also assign privileges at a deeper level if you want/need to be more restrictive.  The virtual folder structure on the Report Server works similar to a file system, inheriting permissions from higher levels unless explicitly overridden at lower levels.

-Ryan

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeff Stahel
Sent: Friday, May 20, 2011 5:57 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] rsaccessdenied

Hello all,

We have just moved to SQL Server 2008 R2 and have set up SSRS. Reports work fine when I am logged into Windows as a domain admin, however regular users are encountering this error:

Normal 0 false false false EN-US X-NONE X-NONE

The permissions granted to user 'Domain\user' are insufficient for performing this operation. (rsAccessDenied) Get Online Help?

Has anybody else run into this? If so, can you please help shed some light on the resolution?

Thank you in advance!

Jeff

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!