Visual Studio 2010
 

Integrate SharePoint 2010 with Team Foundation Server 2010

Book an Expert

 

Our client is using a brand new shiny installation of SharePoint 2010, so now we need to integrate SharePoint 2010 our upgraded Team Foundation Server 2010 instance into it.

In order to do that you need to run the Team Foundation Server 2010 install on the SharePoint 2010 server and choose to install only the “Extensions for SharePoint Products and Technologies”. We want out upgraded Team Project Collection to create any new portal in this SharePoint 2010 server farm.

  • Update 25th September 2012 – Superseded by Integrate SharePoint 2013 with Team Foundation Server 2012
  • Update 4th May 2010 – Nilesh Deshpande from LightSpeedIT in Sydney was asking how he configures SharePoint integration when he has TFS installed on Windows 7. The answer is easy, if not one he will like. You can’t. When you install on Windows 7 you can only do a basic install and the Admin options you would need to configure SharePoint are not available. You will need to move you ProjectCollection to a TFS instance running on a Server OS to be able to do this.

There a number of goodies above and beyond a solution file that requires the install, with the main one being the TFS2010 client API. These goodies allow proper integration with the creation and viewing of Work Items from SharePoint a new feature with TFS 2010. This works in both SharePoint 2007 and SharePoint 2010 with the level of integration dependant on the version of SharePoint that you are running. There are three levels of integration with “SharePoint Services 3.0” or “SharePoint Foundation 2010” being the lowest. This level only offers reporting services framed integration for reporting along with Work Item Integration and document management. The highest is Microsoft Office SharePoint Services (MOSS) Enterprise with Excel Services integration providing some lovely dashboards.

image
Figure: Dashboards take the guessing out of Project Planning and estimation. Plus writing these reports would be boring!

The Extensions that you need are on the same installation media as the main TFS install and the only difference is the options you pick during the install.

image11
Figure: Installing the TFS 2010 Extensions for SharePoint Products and Technologies onto SharePoint 2010

Annoyingly you may need to reboot a couple of times, but on this server the process was MUCH smother than on our internal server. I think this was mostly to do with this being a clean install.

Once it is installed you need to run the configuration. This will add all of the Solution and Templates that are needed for SharePoint to work properly with TFS.

image14
Figure: This is where all the TFS 2010 goodies are added to your SharePoint 2010 server and the TFS 2010 object model is installed.

 image17
Figure: All done, you have everything installed, but you still need to configure it

Now that we have the TFS 2010 SharePoint Extensions installed on our SharePoint 2010 server we need to configure them both so that they will talk happily to each other.
 

Configuring the SharePoint 2010 Managed path for Team Foundation Server 2010

In order for TFS to automatically create your project portals you need a wildcard managed path setup. This is where TFS will create the portal during the creation of a new Team project.
 

To find the managed paths page for any application you need to first select the “Managed web applications”  link from the SharePoint 2010 Central Administration screen.

image
Figure: Find the “Manage web applications” link under the “Application Management” section.

On you are there you will see that the “Managed Paths” are there, they are just greyed out and selecting one of the applications will enable it to be clicked.

image
Figure: You need to select an application for the SharePoint 2010 ribbon to activate.

image
Figure: You need to select an application before you can get to the Managed Paths for that application.

Now we need to add a managed path for TFS 2010 to create its portals under. I have gone for the obvious option of just calling the managed path “TFS02” as the TFS 2010 server is the second TFS server that the client has installed, TFS 2008 being the first. This links the location to the server name, and as you can’t have two projects of the same name in two separate project collections there is unlikely to be any conflicts.

image
Figure: Add a “tfs02” wildcard inclusion path to your SharePoint site.

 

Configure the Team Foundation Server 2010 connection to SharePoint 2010

In order to have you new TFS 2010 Server talk to and create sites in SharePoint 2010 you need to tell the TFS server where to put them. As this TFS 2010 server was installed in out-of-the-box mode it has a SharePoint Services 3.0 (the free one) server running on the same box. But we want to change that so we can use the external SharePoint 2010 instance. Just open the “Team Foundation Server Administration Console” and navigate to the “SharePoint Web Applications” section. Here you click “Add” and enter the details for the Managed path we just created.

image
Figure: If you have special permissions on your SharePoint you may need to add accounts to the “Service Accounts” section. 

Before we can se this new SharePoint 2010 instance to be the default for our upgraded Team Project Collection we need to configure SharePoint to take instructions from our TFS server.

Configure SharePoint 2010 to connect to Team Foundation Server 2010

On your SharePoint 2010 server open the Team Foundation Server Administration Console and select the “Extensions for SharePoint Products and Technologies” node. Here we need to “grant access” for our TFS 2010 server to create sites. Click the “Grant access” link and  fill out the full URL to the  TFS server, for example http://servername.domain.com:8080/tfs, and if need be restrict the path that TFS sites can be created on. Remember that when the users create a new team project they can change the default and point it anywhere they like as long as it is an authorised SharePoint location.

image
Figure: Grant access for your TFS 2010 server to create sites in SharePoint 2010
 

Now that we have an authorised location for our team project portals to be created we need to tell our Team Project Collection that this is where it should stick sites by default for any new Team Projects created.

Configure the Team Foundation Server 2010 Team Project Collection to create new sites in SharePoint 2010

Back on out TFS 2010 server we need to setup the defaults for our upgraded Team Project Collection to the new SharePoint 2010 integration we have just set up. On the TFS 2010 server open up the “Team Foundation Server Administration Console” again and navigate to the “Team Project Collections” node. Once you are there you will see a list of all of your TPC’s and in our case we have a DefaultCollection as well as out named and Upgraded collection for TFS 2008.

If you select the “SharePoint Site” tab we can see that it is not currently configured.

image
Figure: Our new Upgrade TFS2008 Team Project Collection does not have SharePoint configured

Select to “Edit Default Site Location” and select the new integration point that we just set up for SharePoint 2010. Once you have selected the “SharePoint Web Application” (the thing we just configured) then it will give you an example based on that configuration point and the name of the Team Project Collection that we are configuring.
 

image
Figure: Set the default location for new Team Project Portals to be created for this Team Project Collection

This is where the reason for configuring the Extensions on the SharePoint 2010 server before doing this last bit becomes apparent. TFS 2010 is going to create a site at our http://sharepointserver/tfs02/ location called http://sharepointserver/tfs02/[TeamProjectCollection], or whatever we had specified, and it would have had difficulty doing this if we had not given it permission first.

image
Figure: If there is no Team Project Collection site at this location the TFS 2010 server is going to create one

This will create a nice Team Project Collection parent site to contain the Portals for any new Team Projects that are created. It is with noting that it will not create portals for existing Team Projects as this process is run during the Team Project Creation wizard.

image
Figure: Just a basic parent site to host all of your new Team Project Portals as sub sites

You will need to add all of the users that will be creating Team Projects to be Administrators of this site so that they will not get an error during the Project Creation Wizard. You may also want to customise this as a proper portal to your projects if you are going to be having lots of them, but it is really just a default placeholder so you have a top level site that you can backup and point at.

You have now integrated SharePoint 2010 and team Foundation Server 2010!

You can now go forth and multiple your Team Projects for this Team Project Collection or you can continue to add portals to your other Collections.

-Are you having trouble integrating TFS with Sharepoint? Northwest Cadence can help you integrate these two systems together. Contact info@nwcadence.com today to find out how we can help you…

Integrate SharePoint 2010 with Team Foundation Server 2010 was last modified: May 3rd, 2010 by Martin Hinshelwood

-Every company deserves working software that successfully and consistently meets their customers needs on a regular cadence. We can help you get working software with continuous feedback so that your lean-agile teams can deliver continuous value with Visual Studio ALM, Team Foundation Server & Scrum. We have experts on hand to help improve your process and deliver more value at higher quality.

  • Nilesh Deshpande

    Martin,

    I installed Sharepoint 2010 and TFS 2010 on a Windows 7 Ultimate (x64).

    I’m unable to get Team Project automatically create sharepoint portal in this configration.

    I’ve tried enabling Project Portal setting from VSTS > Team > Project Portal Settings menu, however “Use this Sharepoint Site:” radio button is disabled.

    Also, TFS Administration tool does not show Sharepoint Web Applications node (I guess reason being host OS is Windows 7).

    Any help is appreciated.

    Cheers

  • Evgeny

    Sharepoint and Reporting services suported on Windows Server TFS installations only

  • Ron

    I’m looking to build out a new environment with TFS 2010 and SharePoint 2010 and SQL Server 2008 R2.

    I haven’t found any blog posting that discusses using SQL Server 2008 R2. Any advice?

  • Ryan Cromwell

    I assume this was the Sharepoint 2010 beta that’s currently publicly available? If so, does that mean that features like Excel Services that are required for the extended dashboards and reporting in SharePoint 2007 are included in the public beta?

  • Martin Hinshelwood

    Ryan,

    This is the RTM of SharePoint 2010 as it RTM’ed at the same time as Office 2010.

    No, the dashboards and reports are not included in SP2010 as they are added during the install of the “Sharepoint Extensions” part of the TFS 2010 Installer.

    -MrHinsh

  • Mayur

    Need your guidance on below error:
    Default Collection is not created by default when I connect to TFS from client-There is no default collection.
    If I try to create new default collection using existing database called Tfs_DefaultCollection ,SharePoint configuration gives below warning.
    TF249064: The following Web service returned an response that is not valid: http://xxxxxxxx/_vti_bin/TeamFoundationIntegrationService.asmx. This Web service is used for the Team Foundation Server Extensions for SharePoint Products. Either the extensions are not installed, the request resulted in HTML being returned, or there is a problem with the URL. Verify that the following URL points to a valid SharePoint Web application and that the application is available: http://xxxxxx. If the URL is correct and the Web application is operating normally, verify that a firewall is not blocking access to the Web application

  • Martin Hinshelwood

    I need a little more information to help you:

    1. Is this a local SharePoint or is it on a separate server.
    If it is on a separate server please make sure that you have the SharePoint Extensions installed.
    2. What do you get when you connect to http://xxxxxxxx/_vti_bin/TeamFoundationIntegrationService.asmx?
    3. You may be getting a permissions issue between SP and TFS. Check that they have access.
    http://msdn.microsoft.com/en-us/library/bb552177(v=VS.100).aspx

    Let me know how you get on…

  • Matthias Eder

    Thanks for the great post. But unfortunately I got one error when the TFS admin console tries to create the SharePoint site for the team project collection, saying “TF249033: The site template is not available for the locale identifier (LCID). The site template name is: STS#0. The LCID is: 1033″.
    That’s probably because we have a german SharePoint installation. Any idea, how to solve this?

  • Allan

    Great post:) Looking forward to try…

  • Dave

    Hi,
    we successfully migrated from TFS 2008 to 2010.
    Sharepointportals are also working but i have to connect each existing project manually to the corresponing Sharepoint Portal. is there a way to do this automatically?

  • chris

    I can’t see any of your images… are they busted links?

  • Chris

    Actually, just looks busted in chrome. Firefox works.

  • Yoann

    I found a solution for the problem with the LCID (TF249033).

    Just install the Language Packs is the version of your sharepoint (year and SERVER or FOUNDATION SERVICE) and in the language corresponding of TFS (look on the internet to find the language appropriate to the number of the folder which arise problem).

  • Greg Roberts

    Thanks for the post, i paper it seems straight forward but i still haven’t won after many days trying to have a sucessful TFS 2010 install to separate SQL and Sharepoints.

    I don’t get the “Extensions for sharepoints” option at install or maint time so i at a loss of how you got it ?
    I have raised this http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/6eee0a61-c88b-4272-a90e-8797feeb98ee
    and
    http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/486edf00-0b47-40cb-b6cd-b32039a683a2

    Any help appreciated.

    Thanks

  • Dragan

    Integration of TFS 2010 andSharePoint 2010 went fine until I had to configure TFS Reporting (TFS Admin Console->Reporting). In Edit Reporting dialog, Reports tab, I get error ““This operation is not supported on a report server that is configured to run in SharePoint integrated mode.”. My Reporting Services are configured in SharePoint integrated mode. Is it possible to configure TFS Reporting-Reports to work when you have Reporting Services in SharePoint integrated mode?

  • Jon Skrodzki

    I found my solution with http://www.asphostportal.com. Our company trust them to host our sharepoint 2010 site. You can try them. They offer sharepoint 2010 with under $10.00/month. Everything looks great…

  • Rommel Alix

    Hi.

    Thankyou for the great article you wrote here. However, i do have a problem:
    I cant seem to make the “Extensions for Sharepoint applications and Technologies” appear during the installation/update. I am using Windows 7 / SHarepoint 2010 / TFS 2010 /

    SOme notes:

    I managed to configure the Sharepoint and TFS but cant integrate each other using the Team Foundation Server COnsole (cant see the Sharepoitn Web Application under Application Tier)

    Thanx in advance

  • Richard

    How do we run the Extentions for SharePoint Products Configuration Wizard?

  • Francisco

    I am using W7 Ultimate 64 bit, SharePoint Server 2010, TFS 2010.
    I cannot integrate TFS with SharePoint (Standalone installation).
    I need help.
    Thanks.

  • Harishwar Bomma

    Cool.. very nice step by step guide for the configuration…
    Thank you for the post…

  • Nali

    If I have multi SharePoint server farm, do I need to install the TFS integration piece on all the servers? I currently have four SharePoint serves.

  • FDA31090

    Very nice step by step guide, thank you very much.
    I just have a problem to create sharepoint site with the VSTS wizard. I ve get the folwing erro: TFS218017:A SharePoint site could not be create for use as the team project portal. The following error occurred : TF250021: A SharePoinr site cannot be created in the followin location: http:/….. Either the path is not valid , or the Team Foundation server does not support the creation of a site in this path.

    But i can create the site from my TFS console (Create Team Project from vsts without the sharepoint site, and then, create SP site, from the console).

    Any idea for this issue ?

    Otherwise, thank you very much for the post -very, very usefull).

    Thank,
    Regards

  • koncis

    very interesting article, profesional ;)

  • Mark

    http://stackoverflow.com/q/5572282/629174

    Will installing the extensions cause any Application Pool Resets or will it cause any user interruption? It’s a production server and I don’t want to affect any users.

  • Neil

    If I am installing TFS 2010 on a server already running SP Server 2010, then I would select all the components to install BUT the sharepoint extensions, right?

    • Antony Gibbs

      No, all of them…

    • Antony Gibbs

      No, all of them…

  • Pingback: 7 – Install SharePoint « Dr Justin Hale's Blog()

  • Pingback: Integrate SharePoint 2010 with Team Foundation Server 2010 | Ammar's IT Blog()

  • Dean Gross

    I am trying to find a comparsion of what TFS dashboards we would get when integrating with SP 2010 Standard vs SP 2010 Enterprise but have not been able to find anything specific. Do you know where i might be able to find this information? I need to confince some people that the Enterprise version is worth the extra money.

    • http://blog.hinshelwood.com/ Martin Hinshelwood

      You do not get ANY Excel dashboards unless you use Enterprise. You do however still get the Reporting Services ones.

      I could not find a good reference either…

  • Jon Mozley

    I’ve been absolutely baffled by the Microsoft documentation for all this – information overload! Thank you for very clear set of instructions and screenshots.

  • Michael Delaney

    I attempted this step by step.  I have an existing TFS instance on a Server 2008 R2 install that already had SharePoint 3.0 integration.  I have installed a new SharePoint 2010 instance on another 2008 R2 server.  I am trying to serve the project portal for my existing TFS collections on the new SP2010 server.  I am missing something here.  How do i move the existing project collection portal to the new SP2010 server?  The original administrator has since left the group and had no documentation.

    Do I need to export the database from the sql server on the original TFS machine to the new portal machine?  The new machine has SS 2008 R2 on it as the DB server too.  Any advice or step by step guidance would be greatly appreciated.

  • slehman

    I have had TFS 2010 up and running for a year now along with two Sharepoint sites, one for my Intranet and then a separate on when I installed TFS 2010.  I eventually upgraded to use FOundation but had no clue how this all fit together.  Thanks for the info.

    I have an additonal question and hopefully someone can answer this.   The sites that are created I am assuming is being created by the TFS Extensions for Sharepoint. I would like to change the template to not include somethings, add additional documentation libraries,  use some of the webparts that I have created in my Intranet portal for others to use.  where do I find when TFS creates the Portal site what site template it is using?

  • Oleg Simkin

    Would this allow task creation in SharePoint to show up for the developer in TFS?  We would like to have a setup where a BA uses SharePoint to create tasks and the developer sees this Tasks as a Work Item in his Team Explorer.

  • http://www.facebook.com/ahsanleads Ahsan Kabir

    Nice article

  • Pingback: Good tips on getting Team Foundation Server hooked up with an external Sharepoint… | Christopher Knopick | Christopher Knopick()

  • Daniel Raj Indla Joseph

    I’m new to Sharepoint but worked little bit on SharePoint 2010. May I know if TFS Search can be implemented on remote SharePoint 2010 server or both SharePoint and TFS on the same machine? If you have any links or guide will be highly appreaciated.
    Daniel

    • http://blog.hinshelwood.com/ Martin Hinshelwood

      I do not really understand the question as I do not know what “TFS Search” is. What is the result you are trying to achieve?

  • Pingback: Integrate SharePoint 2013 with Team Foundation Server 2013()