SQL Server Reporting services–insufficient rights Error

Http://www.sql-server-performance.com/2011/security-ssrs-reporting-error/SQL Server Reporting services– Insufficient rights Error

by FRANCO LOPES

Introduction

At times if we successfully deploy the reports to the report server and try to view them through Report Manager we E Ncounter am Insufficient rights error. This article focuses on resolving the error.

Solution

After deploying the reports to the report server we can view them in the report Manager Web App provided by Microsoft for Managing, delivering and applying the security to deployed reports. Generally the path to the report server was Http://localhost/ReportServer if it is a default instance orhttp:/ /localhost/reportserver_instancename for a named instance. Similarly the Report Manager can is viewed at http://localhost/Reports for the default instance and Http://lo Calhost/reports_instancename for the named instance.

By default the built-in Administrators group have permission on the report server to access all the reports and the data so Urces deployed on the report server. If you were in the Administrators group come across the following error while viewing the reports

The permissions granted to user ' domain\username ' is insufficient for performing this operation. (rsaccessdenied)

But if is a domain user (which in the most cases we is). You'll have to follow the below steps to resolve the error.

1. Right-click on the Internet Explorer icon and select on Run as Administrator.

2. Type the Report Manager's URL in my case http://localhost/reports

3. The Report Manager window opens where can see various icons and links. Go to Site Settings link on the Report Manager.

4. Click on Security.

5. Click on New Role Assignment and add the Domain\User and depending upon the role of the user in the Organizati On assign them the appropriate role. You can either assign the role of system Administrator or system User both has different rights.  In this example I'll be providing the user with the role of System Administrator. Click Ok.

6. You'll see the user have been added to the role specified. Click on the Home button.

7. Go to the Folder Settings on the Home page.

8. Click on New Role Assignment and add the Domain\User and depending upon the role of the user in the Organizati On assign them the appropriate role. You can either assign the role of the content Manager who can delete, modify and manage all the content on the RE Port server or Browser who can view the reports and subscriber depending upon your need. In this example I'll assign the Content Manager role.

9. You'll then see the user added to the Folder Setting.

Ten. Close the browser which was currently running into the Administrator mode.

Now you can open the Report Manager in my case using http://localhost/reports

SQL Server Reporting services–insufficient rights Error