CODEWITHSUNDEEP
sql-server-2008-r2ssrs-2008ssrs-2008-r2
Our Man in Bananas
Our Man in Bananas

Reputation: 5977

Reporting Services - User management & Security Configuration

I have created an SSRS report with several tables using several stored procedures on SGMIS. The report is to be delivered either by email in PDF format, or should be able to be run by the designated users on demand from the URL

The report runs fine, scheduled run is fine, sends the email with the report in PDF file attached.

Unfortunately whenever the user () tries to run it from the URL, she gets an error message like this:

The permissions granted to user 'mydomain\myAccount' 
are insufficient for performing this operation. (rsAccessDenied) 
(ReportingServicesLibrary)

But the user definitely has all the permissions on the report server and the folder (so \CSC\ and the report itself) – we even checked that she has a login on the SQL Server, and she is mapped to the Public role on there and she has access to the database too.

What else do we need to do in order for a user who is not in the Systems dept. or admins to execute an SSRS report through the URL?

Upvotes: 0

Views: 191

Answers (1)

Lynn Crumbling
Lynn Crumbling

Reputation: 13377

I checked my configuration, and I have the following:

  • Login into the Reports Manager at http://servername/reports

  • Select the folder the contains your reports, then click "Folder Settings". If the base folder contains the report, just click "Folder Settings" immediately.

  • If not already selected, click "Security" on the left sidebar.

  • Click "New Role Assignment".

  • For Group or User Name, enter: NT AUTHORITY\Authenticated Users

  • Check off Browser in the list of roles.

  • Click OK.

Upvotes: 1

Related Questions