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

You are unable to access the reporting site for your TFS (Team Foundation Server) project.  You are able to view individual reports from VS, but you cannot get to the reporting site to edit them.  Whenever you try to go to it (By right clicking on Reports->Show Report Site in Team Explorer), you get the following error page:

SQL Server Reporting Services Error :

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

 

Now, this error message is fairly well described but almost every solution work towards that you don't have any permission set in Reporting Services.

 

You need to set the permissions up via SQL Server Management Studio. Run it
as administrator, click Connect in Object Explorer, select Reporting Services
from the dropdown, then enter server name.

1.JPG

Once connected, right click on Home and do Properties,

2.JPG

 then you can add your user and apply the permissions you need.

3.JPG


Up Next
    Ebook Download
    View all
    Learn
    View all
    F11Research & Development, LLC