The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

Solution 1:

It's because of lack of privilege for the user you are running the report builder, just give that user or a group a privilege to run report builder. Please visit this article

Or for shortcut:

1. Start Internet Explorer using "Run as Administrator"
2. Open http://localhost/reports
3. Go to properties tab (SSRS 2008)
4. Security->New Role Assignment
5. Add DOMAIN/USERNAME or DOMAIN/USERGROUP
6. Check Report builder

Solution 2:

I know it's for a long time ago but you (or any other new comers) can resolve this issue by

1. Add the [Domain\User] to Administrator, IISUser, SQLReportingUser groups
2. Delete Encryption Key in SSRS configuration tools
3. ReRun the Database Change in SSRS configuration tools
4. Open WebServiceUrl from SSRS configuration tools (http://localhost/reportserver)
5. creating Reports Folder manually
6. go to Properties of created folder and add these roles to security (builtin\users , builtin\Administrator, domain\user)
7. Deploy your reports and your problem resolved

Solution 3:

Right Click Microsoft BI -> Click Run as Administrator -> either open your existing SSRS report or create your new SSRS report and then deploy your report after that complied you will be received one web URL for to view your report. Copy that URL and paste to web browser(Run as Administrator) and you will get your report view. You could use Internet Explorer, which would be essential for web service

If it is wrong means,Please forgive me since i did like this so that i just written.

Solution 4:

Make sure you have access configured to the URL http://localhost/reports using the SQL Reporting Services Configuration. To do this:

1. Open Reporting Services Configuration Manager -> then connect to the report server instance -> then click on Report Manager URL.
2. In the Report Manager URL page, click the Advanced button -> then in the Multiple Identities for Report Manager, click Add.
3. In the Add a Report Manager HTTP URL popup box, select Host Header and type in: localhost
4. Click OK to save your changes.
5. Now start/ run Internet Explorer using Run as Administator... (NOTE: If you don't see the 'Site Settings' link in the top left corner while at http://localhost/reports it is probably because you aren't running IE as an Administator or you haven't assigned your computers 'domain\username' to the reporting services roles, see how to do this in the next few steps.)
6. Then go to: http://localhost/reports (you may have to login with your Computer's username and password)
7. You should now be directed to the Home page of SQL Server Reporting Services here: http://localhost/Reports/Pages/Folder.aspx
8. From the Home page, click the Properties tab, then click New Role Assignment
9. In the Group or user name textbox, add the 'domain\username' which was in the error message (in my case, I added: DOUGDELL3-PC\DOUGDELL3 for the 'domain\username', in your case you can find the domain\username for your computer in the rsAccessDenied error message).
10. Now check all the checkboxes; Browser, Content Manager, My Reports, Publisher, Report Builder, and then click OK.
11. You're domain\username should now be assigned to the Roles that will give you access to deploy your reports to the Report Server. If you're using Visual Studio or SQL Server Business Intelligence Development Studio to deploy your reports to your local reports server, you should now be able to.
12. Hopefully, that helps you solve your Reports Server rsAccessDenied error message...

Just to let you know this tutorial was done on a Windows 7 computer with SQL Server Reporting Services 2008.

Reference Article: http://techasp.blogspot.co.uk/2013/06/how-to-fix-reporting-services.html