TFS 2008 SP1 + SQL 2008 SP1 Installation Dance

When I install TFS 2008, I always install it with SQL 2005.  They’re like an old couple and they go well together  ;-)

For a change, I installed TFS 2008 with SQL 2008 SP1 today.  First thing, you need to do the merge dance by merging the application tier setup files with the TFS SP1 files.  The procedure is clearly described in the TFS installation guide.  None the less, TFS refuses to install saying that it doesn’t like the SQL Server version.   Grrrrr!

Well looks like I needed to do a second dance, this time it was the XML dance.  Basically, you need to update the Hcpackage.xml file with some different version numbers so that setup can view SQL 2008 SP1 as an OK version.  The procedure can be found here:
http://support.microsoft.com/kb/969985

And they lived happily ever after  :-)