"The permissions granted to user '' are insufficient for performing this operation."
We are unable to access the reporting site for our TFS project. We are able to view individual reports from VS, but we cannot get to the reporting site to edit them. Whenever we try to go to it (By right clicking on Reports->Show Report Site in Team Explorer), we get the following error page:
SQL Server Reporting Services
Error
The permissions granted to user '' are insufficient for performing this operation.
The URL it's hitting is:http://[OurServer]/Reports/Pages/Folder.aspx?ItemPath=/[OurProject] I've checked the permissions for reporting services using the TFS Admin power toy, and all users have full permissions. Is there somewhere else that we need to grant permission?
Thanks.
Thomas,
I have a similar problem to yours which I have struggled with for some time now. I posted a message about that on the Team Foundation Server - Setup thread.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1164416&SiteID=1
If you find a solution or have any other information on the matter, please post a note about it here. I would appreciate that a lot.
Regards,
Tobias Nyberg
We discovered that our Reports virtual directory in IIS was set to allow anonymous access. We disabled anonymous access on this directory and the reporting site appears to be mostly working now. It looks like the reports in VS are in the ReportsServer virtual directory. That directory was always set to deny anoymous access.
I am having the same issue as the thread starter. I can access the reports but when I add users to the Team Project also usign the TFS Admin tool the Team Project users see the following message.:
The permissions granted to user 'MYDOMAIN\JOHNDOE' are insufficient for performing this operation. (rsAccessDenied)
I had the same with an other project and for some reason a couple of hours later they could see the reports whilst nothing changed. I have a dual-server deployment of TFS. All these users have the Publisher rol and I have also tried to delete them and re-add them but that didn't change anything.
Also anonymous access is already disabled.
I have the same error...
And I think that started to happen after the update with the SP2 of sql server 2005...
When adding new users as a Contributor using the TFS Admin Power Toy it adds the user to Publisher role on the Reporting Server but this is not enough as this role cannot view the reports you also need to add the user to the Browser role.
Logonto the report server and go to the properties tab of the folder for which you want to set the permissions. In the security tab add the new role assignment and select browser role. That should do.
Check this link for more info : http://msdn2.microsoft.com/en-us/library/aa337471.aspx
I got around this error by opening Internet Information Services (IIS) Manager and disabling "ASP.NET Impersonation"
It is so simple,,,,go to IIS and try the properties on the reportserver directory,,,,then directory security and then edit,,,,click browse ahead of user name and then advance and then find,,,,,,select administrator and then ok and apply the setting ,,,that should solve the problem.
Sayed
Try running the browser as administrator.
If anyone is still struggling with this problem, I think we've found the solution and posted it here. For us it was the fact that the TFS Administration Tool defaults a TFS "Contributor" to the "Publisher" role in Reporting Services. In our Reporting Services instance, Publisher had permissions to publish, but not View a report. We didn't change anything out of the box, so I'm guessing that is how it's shipped, which makes no sense at all to us. It's like giving me permissions to deposit money into my check book, but removing my permissions to view the balance sheet.
