A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
In SSRS, access is granted by assigning users or groups to roles on the report server and/or specific folders/reports. To let someone run reports, add their Windows account or an AD group to an appropriate role (for example, Browser or a custom view-only role).
Basic steps in the SSRS web portal (native mode):
- Open the report server web portal.
- To grant server-wide access (optional):
- Select the gear icon in the upper-right corner → Site settings → Security.
- Select Add group or user.
- In Group or user, enter the Windows domain user or group in the format
<domain>\<account>. - Select a system role (for example, System User) and select OK.
- To grant access to run reports in a specific folder or report:
- Browse to the folder or report.
- Open its security/permissions (for example, Manage → Security or Folder Settings → Security, depending on version).
- If needed, break inheritance (for example, Edit Item Security → OK when prompted that security is inherited).
- Select New Role Assignment / Add group or user.
- Enter the user or AD group (
<domain>\<account>). - Select a role that allows viewing/running reports, such as Browser.
- Select OK.
After this, the user (or anyone in the group) can browse to the portal and run the reports covered by the role assignment.
If using Service Manager standard reports, grant SSRS permissions similarly at the root or specific report folders so non-admin users can see and run reports from the Reporting workspace.
References: