At the time of configuring the Team Foundation Server sometimes you will come across an error as below :
TF218017: A SharePoint site could not be created for use as the team project portal. The following error occurred: TF249063: The following Web service is not available: http://sourcecontrol/_vti_bin/TeamFoundationIntegrationService.asmx. This Web service is used for the Team Foundation Server Extensions for SharePoint Products. The underlying error is: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.. Verify that the following URL points to a valid SharePoint Web application and that the application is available: http://sourcecontrol. If the URL is correct and the Web application is operating normally, verify that a firewall is not blocking access to the Web application. (type TeamFoundationServerException)
please refer following link to sort out the problem :
http://social.msdn.microsoft.com/Forums/en-US/tfsadmin/thread/78c467a5-d163-4bc7-b02b-24f9147e182c/
Configuring SharePoint Server 2010 for Dashboard Compatibility with TFS 2010
http://blog.hinshelwood.com/integrate-sharepoint-2010-with-team-foundation-server-2010/
related references :
http://www.readmespot.com/question/f/180856/integration-of-sharepoint-2010-with-tfs2010
when you try to browse the burntdown, bugs, etc charts via the team foundation project port you will get the following error with the excel pivot charts.
Error: Unable to retrieve external data
Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: PowerPivot Data
refer following link for more details :