Configuring SharePoint Server 2010 for Dashboard Compatibility with TFS 2010

Team Foundation Server 2010 supports integration with both Microsoft Office SharePoint Server (MOSS) 2007 and Microsoft SharePoint Server 2010.

For those of you who wish to integrate with 2007, this MSDN topic gives instructions for configuring SharePoint settings so that the TFS dashboards built for MOSS light up on your SharePoint server.

For those of you who wish to integrate with SharePoint 2010, the steps are slightly different (and easier given the improvements in the configuration experience that the SharePoint team has made for 2010). This blog post describes these steps, which involve configuring Secure Store Service and Excel Services. The steps for configuring Secure Store Service, which is the replacement of MOSS 2007’s Single Sign-On, is optional, but recommended if you don’t want to manually give credentials in SQL Reporting Services to everyone who is accessing the portal, and/or your SharePoint server is on a separate machine from your Team Foundation Server, and you need to solve the double-hop authentication issue.

Verify that Excel Services and (optionally) Secure Store Service are Enabled

First, you’ll want to verify that Excel Services and, optionally, Secure Store Service have been enabled on your SharePoint server. To do so, you can use the farm configuration wizard (if you have just done a fresh install of SharePoint Server 2010, you’ll see this screen pop up when you first open SharePoint Central Administration) and pick the “Walk me through…” option:


On the next screen, make sure that Excel Services and Secure Store Service are checked:


If they are not, go ahead and check them and click Next to enable them.

Configure Excel Services

Go to the central administration home page, and click on “Manage service applications” under Application Management…


…and then click “Excel Services Application”. Click on “Trusted File Locations”. By default, SharePoint creates a trusted file location of “http://” when you first configure Excel Services, which makes any path under the root a trusted location; you can change this if you wish, but make sure that the path maps to a location under which you want to place your TFS team project SharePoint portals, and that Trust Children is set to true. Click on the address of the trusted file location that will be used for TFS to edit it.


Scroll down on the form and find the Warn on Refresh option, and uncheck the checkbox. If you leave this option checked, users visiting the TFS dashboards on SharePoint will constantly be asked whether they want to refresh the Excel web parts. Click OK.


Configure Secure Store Service (optional)

Configuring Secure Store Service is optional, but recommended if you don’t want to manually give credentials in SQL Reporting Services to everyone who is accessing the portal and/or your SharePoint server is on a separate machine from your Team Foundation Server, and you need to solve the double-hop authentication issue.

Go to the central administration home page, click on “Manage service applications” under Application Management, and then click on Secure Store Service.

On the resulting page, SharePoint will tell you that you need to generate a key if you haven’t done so already:


Click on Generate New Key on the ribbon if this is the case. Once you’ve got a key, click New on the ribbon to create a new Secure Store Target Application for TFS. Fill out the appropriate fields, and take a note of the value you specify for the Target Application ID, as you’ll need this later (I used tfs in the example below). Select Group for the Target Application Type:


Click Next, and accept the default settings on the next page:


On the next page, enter the administrator account(s) that you want to be able to manage the Secure Store Target Application in the Target Application Administrators field. For Members, enter the users and/or groups that you wish to give access to your TFS dashboards that will be created with your team projects. Then click OK.


Once you’ve clicked OK, you’ll return to the list of Secure Store Target Applications. Select the one you’ve just created and click Set Credentials.


In the resulting pop up dialog, type in the username and password of the TFS data sources account for SQL Server Reporting Services. See this MSDN topic for more information on the accounts used for TFS (the data sources account is referred to as TFSReports in that topic) and the specific requirements of the data sources account. Click OK.


Configuring TFS 

Now onto configuring TFS. If you haven’t already installed/configured TFS, do so now, following the instructions in the install guide to enable TFS integration with SharePoint. Once you have installed/configured TFS, open up your TFS admin console on the machine where SharePoint is installed. Select the “Extensions for SharePoint Products” node and select the mapping to TFS and click Modify. In the Enterprise Application Definition field, enter in the value that you specified earlier for the Target Application ID when configuring Secure Store Service (I used tfs above and below).


That’s it!

Your 2010 SharePoint Server is now set up for TFS dashboard compatibility.

Edit (6/1/10): This post originally outlined steps for the SharePoint Server 2010 Beta. I’ve updated the instructions and screenshots for SharePoint Server 2010 RTM.

image My name is Jon Tsao, and I am a Program Manager for the work item tracking and project management team for Team Foundation Server.
Comments (6)

  1. John, thanks for this! It is so very timely and looks much simpler than the procedures for MOSS 2007. I’ll let you know how it goes.  🙂

  2. Sarah says:

    Does moss 2010 integrated with tfs include a wiki suitable to use as a team collaboration tool?

    If so, does it allow tag and search, tag clouds etc…?  Does it allow links to tfs items such as changesets, work items or ability add dynamic graphs/reports based on tfs data?

    We’re looking for a wiki tool with better features and integration with tfs than tfs 2010 "Team Wiki".

  3. Hi – this is good. Could you do an update for the RTM version as the above is not what i see (specifically the "Services on Server" behaviours are completely different).

  4. mcodyw says:

    Is Kerberos an option?  We use kerberos exclusively on our 2007 environment and will be doing so in 2010 also.  However the documentation for integrating with 2007 says that you must use a web app that uses NTLM.  Is that true?  If so, is it still true in SP 2010?  


  5. Thank you for this article, however I am having one issue. Running the RTM of SharePoint 2010 – even after confirming that the "Excel Application Services" are checked in the Farm Configuration Wizard – I do not see it listed under the "Services on Server" screen – only the Excel Calculation Services which is grayed out (though running).

    Am I overlooking something obvious?

  6. jontsao says:

    @Sarah: Yes, MOSS 2010 includes a simple wiki; I don't believe it offers tagging though, nor does it tightly integrate with TFS. You can create custom SharePoint dashboards with links to tfs data/embedded graphs reports on either SharePoint 2007 or 2010, but the wiki functionality of SharePoint is not part of the dashboards.

    @Steven: Yes, sorry about that. I've now updated the blog post for RTM. Thanks!

    @mcdoyw: Yes, I believe Kerboros is supported with SP (2007 or 2010) as well, but let me double check about the documentation.

    @Richard: Sorry about that; those instructions were based on the Beta. The post is now updated for RTM. You can find "Excel Application Services" option under "Application Management" -> "Manage service applications".