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.
Once connected, right click on Home and do Properties,
then you can add
your user and apply the permissions you need.