Adding a new role type to Reporting Services

reporting-services roles user-management
William picture William · Oct 31, 2011 · Viewed 9.6k times · Source

Is there a way to add new roles to reporting services?

I'm working on a clients project and it requires a custom role in Reporting Services. I can't find any page in my http://localhost/reports that will allow me to configure a new role. I can only assign users and groups to existing roles.

I looked in the [ReportServer].[dbo].[Roles] table of my database and found the current roles but I'm not sure what some of the columns do/mean so I don't want to just go adding a new record.

Answer

Jamie F picture Jamie F · Nov 1, 2011

You can certainly create new roles: https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-create-delete-or-modify?view=sql-server-2017

This is done through a seldom-used feature of SSRS: you connect to SSRS through the SQL Server Management Studio (SSMS) by specifying a server type of "Reporting Services"

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More