TFS 2008 with MOSS 2007

Over the past couple of weeks we have been in the process of setting up MOSS in preparation of a company wide roll-out. In addition we have been setting up Team Foundation Server 2008 for preparation of roll-out within our development and product management teams. When a project is created in TFS it does a couple of things, one of which is to create a sharepoint site (WSS 3.0). This is great but in our scenario the TFS server was different than our MOSS server. Ideally we wanted to have each TFS site under a main development site collection in MOSS. I'm sure there is a better way to do this but if you're in our scenarion and have them setup already then there is a way you can accomplish this.

Inside the TFS database "TfsIntegration" there is a table called "tbl_service_interface". If you inspect the data in this table you will see a couple wss related entries. by simply modifying certain entries I was able to point WSS to a subsite in MOSS. Here are the entries:

BaseSiteUrl
It will be something like this: http://[tfs server]:80/sites. I just changed it to http://[mossserver]/development. Remember I had a site collection called development at the root level in MOSS.

BaseServerUrl
Same as above.

Now, there are a couple of gotchas here!

1) I have NOT tested creating new projects in TFS. I'm sure this will probably break that process. In my scenario I will very rarely, if at all, create new projects so in that case I'll just change the settings back to what they were before.

2) You need to create the associated site in MOSS. The site name will be the same as the TFS project name.

Note: This is a hack! Use at your own risk!