Monday, June 15, 2009

Installing Visual Studio 2008 Team Foundation Server with SQL Server 2008

Out of the box, you cannot install Team Foundation Server 2008 with SQL Server 2008.  You’ll get errors telling you that you’re using an incompatible version of SQL Server or that full text search isn’t installed or running.  So after re-installing different flavors of SQL Server 15 times, building a Windows Server 2008 image from scratch, re-installing SQL Server another 15 times on the new image, and 5 cups of coffee later, you might just end up contemplating a career change.  Or, you could just read this and get on with your life.

In a nutshell, you need TFS SP1 to work with SQL 2008.  And you need TFS to install TFS SP1.  :)  The solution is in this blog entry and requires an integrated install:

msiexec /a AT\vs_setup.msi /p SP1\TFS90sp1-KB949786.msp TARGETDIR="C:\Documents and Settings\MyUser\Desktop\ATSP1"

No comments:

Post a Comment