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, http://support.microsoft.com/kb/969985, 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 :)