In this article, we will see how to set user access roles and permissions for a specified user in SQL Server Reporting Services. User permissions in SSRS server is a big challenge for accessing the server for specified users. In this article, we will see how to add a new user role and provide permissions for the user to access particular components of the server reports. Let us see the step-by-step process on how to create user role and permission on the server.
First, let us step into the Report Manager by accessing the local URL or server URL,
http://localhost/reports. With this we can see the user interface as shown in the screen below.
Now click on the Site Setting link at the top right corner. This will navigate us to a new window as shown in the screen below. Click on Security link at the left side menu to proceed further.
Here we can see BUILTIN\Administrators user assigned to System Administrators role as shown in the screen below.
Now let us add a new user to the role. Click on the New Role Assignment menu button as shown in the screen below.
An admin screen will appear with an option to enter the user name to which we need to assign the role. In addition, we can see the list of roles that can be assigned to the specific user as shown in the screen below.
Enter the user name, select the roles based on the requirement and click on OK to add the user as shown in the screen below.
Clicking on OK will take some time to execute and create a user with the permissions. Once the process is completed, we can see the user with the role listed as shown in the screen below.
Next is to assign the user to the specific role. Go back to Home page and click on properties tab as shown in the screen below.
Navigating to the Properties tab, we can see the option to add New Role Assignment. Clicking it will navigate the user to the other page with the list roles that can be assigned to the user as shown in the screen below.
Now enter the user, select the respective roles, and click on OK as shown in the screen below.
Click on OK and once the roles are added to the user we can see the list as shown in the screen below.
So in this article we have seen the user and role permission setting for the SSRS server. Role with user permissions are the major thing for an administrator to assign specific roles as per the user requirement to handle the server.