CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012
Gyuzal
Gyuzal

Reputation: 1591

SSRS user access to specific folders

I'd appreciate if anyone could provide a clear description on SSRS user access configuration.

I've installed latest SSRS and its database on a single server, set the web portal and everything works fine, except I cannot grant access to a specific user group for a specific folder. Till now all the users have access to everything.

I've been struggling with this for several weeks and still couldn't find any tutorial.

Upvotes: 2

Views: 2466

Answers (2)

Mike Honey
Mike Honey

Reputation: 15017

You have probably added the user group to a role using the Site Settings / Security page, or added them to the Home folder / Manage / Security page. A typical user group should not appear in either list.

Instead, navigate to the "specific folder" / Manage / Security page, click Customize security (if required) and then assign the user group to a role (typically Browser).

Here's the full doco on those tasks:

https://learn.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-2017

Upvotes: 2

Dalibor Grudenic
Dalibor Grudenic

Reputation: 505

Based on documentation Reporting Services provides an authentication subsystem and role-based authorization model. Authentication and authorization models vary depending on whether the report server runs in native mode or SharePoint mode. Here is detailed explanation called Secure Reports and Resources related to native mode and this one talks about Set Permissions for Report Server Operations in a SharePoint Web Application. Also this youtube tutorial and this one was helpful to get me started.

Upvotes: 2

Related Questions