When you install a Reporting Service Point in ConfigMgr 2012, you might want allow your users to be able to manage Subscriptions to the reports through the web interface of SSRS. In the default setup, the behavior is that only ConfigMgr Report Administrators (SSRS Security Role) have those permissions.

Issue

When a user that is a member of the ConfigMgr Report Users security role select the option Subscribe on a certain report, as shown in the picture below:

132_1

They get presented with an error message that reads:

ERROR You do not have permissions to access this page

A more detailed picture of the error message is shown below:

132_2

Solution

In order to solve this issue, open SQL Server Management Studio elevated on the Site server where the Reporting Service Point is installed, or run it remotely if it’s not installed on the Site server.

1. In the Connect to Server dialog window, select Reporting Services as Server type, make sure that the correct Server name has been entered and click Connect.

132_3

2. Expand Security and then Roles. Right click on ConfigMgr Report Users and select Properties.

132_4

3. In the User Role Properties – ConfigMgr Report Users window, put a check mark in the box next to Manage individual subscriptions and click OK.

132_5

4. Now instruct the user to refresh the browser and try to Subscribe to the report again. They should now be presented with the following page:

132_6

I hope this helps!

Nickolaj Andersen
Principal Consultant and Enterprise Mobility MVP. Nickolaj has been in the IT industry for the past 10 years specializing in Enterprise Mobility and Security, Windows deployments and Automation. In 2015 Nickolaj was awarded as PowerShell Hero by the community for his script and tools contributions. Author of ConfigMgr Prerequisites Tool, ConfigMgr OSD FrontEnd, ConfigMgr WebService and a frequent speaker at user groups.

(324)

There are no comments.

Leave a Reply