TFS upgrade from SQL Server 2005 to SQL Server 2008

Hey, 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……

1

TFS on 64bit… Did I hear a NO CAN DO?

Sitting at a customer we just spedified a new server to host our TFS for internal use… We got our hands on a quad cpu Opteron with 8gb ram… of course we wanted to utilize the 8gb memory, and therefore told the outsourcing partner that they should roll on 64bit Windows 2003 r2. As everyone…

5