Welcome to MSDN Blogs Sign in | Join | Help

Using SQL 2008 SP1 with TFS 2008 SP1

You may have noticed that SQL 2008 SP1 was recently released.  I've seen a flurry of questions about whether or not TFS 2008 SP1 will work with SQL 2008 SP1.  The good news is that the answer is yes.  The bad news is that there's a work around you may have to do 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 tell you the SQL version is incompatible.

Because of the nature of the problem, the install order matters.  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.

The process has been documented in this KB article.

Brian

Published Wednesday, April 15, 2009 4:24 PM by bharry
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Using SQL 2008 SP1 with TFS 2008 SP1 | ASP NET Hosting

PingBack from http://asp-net-hosting.simplynetdev.com/using-sql-2008-sp1-with-tfs-2008-sp1/

Wednesday, April 15, 2009 5:02 PM by Using SQL 2008 SP1 with TFS 2008 SP1 | ASP NET Hosting

# re: Using SQL 2008 SP1 with TFS 2008 SP1

Thanks Brian -

What I'd really like to know is, can you use SQL Management Studio (SQL 2005 or SQL 2008) with TFS version control in order to check in SQL scripts into source control seamlessly.  Or are we limited to using VSTS DB Edition?  If it's the latter, where can I find some more reference material, webcasts, etc. on this topic?

Thursday, April 16, 2009 1:07 PM by Matt R

# re: Using SQL 2008 SP1 with TFS 2008 SP1

Matt:  Sort of.  If you install the MSSCCI provider for TFS, you'll have TFS source control integration in SSMS.  It's not as nice as the Team Explorer integration in VS, but it does work.

Thursday, April 16, 2009 6:33 PM by CPDaniel

# re: Using SQL 2008 SP1 with TFS 2008 SP1

That's what I was going to say :)  You can get the TFS MSSCCI provider here: http://www.microsoft.com/downloads/details.aspx?familyid=FAEB7636-644E-451A-90D4-7947217DA0E7&displaylang=en

Brian

Friday, April 17, 2009 7:40 AM by bharry

# re: Using SQL 2008 SP1 with TFS 2008 SP1

And if you really want to up your game with respect to database development then DBPro is definitely the way to go. Check out http://blogs.msdn.com/gertd - Gert has a ton of great information on his blog, including links to webcasts. I have been using DBPro for a personal project a lot over the last few weeks and it's become my best friend. :-)

Friday, April 17, 2009 5:23 PM by briankel

# VSTS Links - 04/20/2009

The Accentient Blog on Microsoft (Team System) makes it to the upper-right (leaders) quadrant Brian Harry

Monday, April 20, 2009 7:17 AM by Team System News

# Install TFS 2008 SP1 with SQL Server 2008 SP1

This just spent me couple hours to find out, that you won't be able to install TFS 2008 SP1 on SQL Server

Monday, May 18, 2009 11:05 AM by Rexiology@MSDN

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker