Setup Team Foundation Server 2010 with Sharepoint 2007 on Window Server 2008 SP2

Wow what a task!

If you have Office SharePoint 2007 no SP you need to follow these steps:

 http://www.christiano.ch/wordpress/2009/09/16/microsoft-office-sharepoint-server-2007-on-windows-server-2008-this-program-is-blocked-due-to-compatibility-issues/

Next install SQL Server, SharePoint etc... steps:

http://juliocasal.com/archive/2009/11/02/team-foundation-server-2010-beta-2-office-sharepoint-server-2007-single-server-installation-part-1.aspx

Next install Team Foundation Server 2010 steps:
http://juliocasal.com/archive/2009/11/02/team-foundation-server-2010-beta-2-office-sharepoint-server-2007-single-server-installation-part-2.aspx

5Hours later and I am ready to roll!

Notes: Struggle on SSO Service Account: http://thorprojects.com/blog/archive/2008/08/02/moss-single-sign-on-setup-step-by-step.aspx

When creating a new TFS project and setting the SharePoint site up the user must be added to the SharePoint permissions:

1. Using the TFS Setup account, navigate to http://myserver/sites/DefaultCollection 
2. Click on Site Actions and select Site settings. 
3. Under Users and Permissions, click the link Site collection administrators
4. Added my account in the domain/account format and clicked ok

Excel Services was unable to load the workbook that you requested:
Give NT AUTHORITY\NETWORK SERVICE  (db owner) on the database named "WSS_Content"