Tuesday, March 27, 2012

Rolling out TFS 11: Update your SQL Server first

Last week I finally had some time to start migrating our TFS 2010 environment to the TFS 11 beta. The first time I tried to do the migration it failed because I didn’t had the latest updates installed for SQL Server 2008 R2. The installation procedure mentions that you need at least SQL Server 2008 R2 with SP1 and Cumulative Update 1 installed.

So to get everything working, first install SP1: http://www.microsoft.com/download/en/details.aspx?id=26727

Afterwards you can download and install the Cumulative Updates(I think Cumulative Update 4 is the latest version): http://support.microsoft.com/kb/2633146.

Don’t try to mix the order, in that case you’ll end with the following error message(or something similar) during installation:

The version of SQL Server instance MSSQLSERVE does not match the version expected by the SQL SErver update. The installed SQL Server product version is 10.50.1600.1, and the expected SQL Server version is 10.51.2500.0.

No comments: