Thursday, 6 July 2017

SSRS Role Assignment OR Manage User Access


If we need to assign Role(User Access), we need to connect to the Report Manager URL as an admin.

Connecting to Report Manager as an Admin:
Case-1: 
If the Report Manager is not using windows authentication then use the admin credentials to connect to the Report manager

Case-2:
If the Report Manager is using windows authentication (not prompting user name and password). Login to the Server (Where the SSRS software is installed) as an administrator and connect to the Report Manager URL.

Case-3:
Report Manager is not prompting user name and password, but we are getting below error.

User 'admin-PC\admin' does not have required permissions. Verify that sufficient permissions have been granted and Windows User account Control (UAC) restriction have been addressed.

Follow the below steps:
Close the browser and open the browser as an administrator (follow the below steps)
  • Right Click on the browser and select the option "Run as an Administrator".
  • Once the browser is opened then enter the "Report Manager" URL and connect.

Role Assignment OR Manage User Access:
  • Once we connected to the Report Manager, click on the "Folder Settings" (highlighted in the below image)
  • Then click on "New Role Assignment".
  • Once the "New Role Assignment" page is opened, enter the User/Group name and select the role which we need to assign.
  • Click on "OK" button. We can see the newly add Role in the below screen.
  • If we need to Change/Delete the current roles, select the required role (select the check box) and use the "Edit/Delete" options (Highlighted in the below screen.

No comments:

Post a Comment