Using SQL 2008 SP1 with TFS 2008 SP1
by Olga Belokurskaya
As you already know, Microsoft made SQL Server 2008 Service Pack 1 available about a week ago. You may also know, that a lot of folks have been confused by the installation problems, so lots of questions arose round this very service pack.
Brian Harry, for example, has been attacked with questions about whether or not TFS 2008 SP1 will work with SQL 2008 SP1, according to his latest blog post. There he reassures TFS 2008 users that it, certainly, will, but… But they’ll have to do quite a piece of work to get it to install.
The problem has to do with version checks that the TFS installer does to ensure the SQL version is compatible. The checks are too restrictive and even though it will actually work, the installer will insist on incompatibility of the SQL version.
The solution is the install order. According to Brian
If you already have TFS 2008 SP1 running with SQL 2008, and you want to upgrade SQL to 2008 SP1, that will just work - because you aren’t running TFS setup where the block happens. If, on the other hand, you want to install TFS 2008 SP1 using an already installed SQL 2008 SP1 server, you will need to modify an XML file to get around the block.
Microsoft explains the process in this .





