TFS upgrade from SQL Server 2005 to SQL Server 2008


I just upgraded my TFS server to run SQL Server 2008, believing that this would be a straight out the box upgrade... but boy was I wrong!

After the upgrade none of my projects could connect to the TFS. And I instantly knew it was b/c of SQL Server 2008.

So what to do...

Searched and browsed the web and everywhere I looked, almost, was saying that the CTP of 2008 would work.
But apparently we did some updates to the RTM that messed this up.

I found this KB article,, describing the procedures. So after hacking the XML file and do an uninstall of the TFS and then reinstalling it, I am back online.

PHEW, I thought I had lossed my dearly beloved code, and version control :)