Error : The permissions granted to user "Domain\User" are insufficient for performing this operation. (rsAccessDenied) in SSRS

à Connect Sql Server Management Studio

à Go to sql jobs

à In security

à In roles, go to system roles

à Add new system role

à Then grant the new role “Execute Report Definitions” permission

Finally add the user account to the new system role, this is done in report manager under Site Settings à Security 

à New Role Assignment.

OR

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 you can see various icons and links. Go to site
settings link in 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 organization assign them the appropriate role. You can either assign the role of System Administrator or System User both have different rights. Click Ok.

6. You will see that the user has been added to the role specified. Click on 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 organization 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 report server or Browser who can view the reports and subscriber depending upon your need.

9. You will then see the user added to the Folder Setting.

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

11. Now you can open the report manager in my case using http://localhost/reports