I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010.
I am being prompted for a username and password in Excel for any given Team Project when right clicking the item "Active Tasks", selecting "Create a Report in Microsoft Excel," found in the following path within the Team Explorer pane, from Visual Studio 2010:
'Collection Name' | 'Project Name' | Work Items | Iteration 1 | Active Tasks
I am a Team Project Administrator and Collection Administrator. I checked The SharePoint site:
http :// 'serverName'/Reports/Pages/Folder.aspx
and have full sitewide and project permissions on this site.
I loaded SQL Server Management Studio on the machine running the instance of TFS (and also the SQL backend for TFS) and ensured that I had roles "serveradmin" and "sysadmin".
How do I run this report? Specifically, what permissions are required?