Today I was working with a client that wanted to install the recently released SQL 2008 Service Pack 1 on their TFS Server. They were eager to know if the SQL Service Pack would be compatible with TFS 2008 SP1.

The good news is that you can install SQL 2008 SP1 onto your TFS server if you happen to have installed TFS with SQL 2008. Brian Harry has the details on his blog at http://blogs.msdn.com/bharry/archive/2009/04/15/using-sql-2008-sp1-with-tfs-2008-sp1.aspx

NOTE: As stated in Brian’s blog post, if you are installing TFS 2008 onto a SQL 2008 instance with SP1 already installed, you will need to use the workaround in the KB article he references .