Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

That's not a permission denied message you're receiving, so it's not likely you'll rid yourself of it by adding more permissions. What happens when you fill out the username and password? I don't see this behavior, and I run reports with Excel all the time. I wonder if something gets cached after the first authentication?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.