Upgrade TFS to service pack 1, when SQL Server 2005 does'nt have a service pack

Posted on 2007-07-23
Medium Priority
Last Modified: 2013-11-26
We have Team Foundation Server that needs to have service pack 1 applied to it, but the SQL Server 2005 currently does not have any service packs applied.
I need to know what is the best upgrade path to take to finally have TFS @ sp1 and SQL Server 2005 @ sp2.
1. Will TFS sp1 require SQL Server 2005 to have at least service pack 1 applied before successfully installing? E.g. will TFS complain if SQL Server doesn't have a service pack!
2. Can I install TFS sp1 and then apply SQL Server 2005 sp2?

What is the best approach to upgrade please?
Question by:hayesnic
  • 2
LVL 12

Expert Comment

ID: 19549101
See http://support.microsoft.com/default.aspx?scid=928957

TFS is not dependent on SQL SP installation.

Author Comment

ID: 19554260
Hi Patrikt,
Thanks for the quick response.
I've checked out the link to the MS Support KB, but can't find where it says:

"TFS is not dependent on an SQL SP".

Can you indicate where in the attached link it says or implies this comment please.
Excuse me for my caution but I need to get this right on the 1st attempt!

If this comment is true then does that mean that it would be OK to upgrade SQL to SP2 and then upgrade TFS to SP1 afterwards without incidences?

LVL 12

Accepted Solution

patrikt earned 2000 total points
ID: 19554479
The MS notes are written in positive way only so you will not find "Not dependent on" statement. Just check Requirements section and find no sql there.
As TFS can run on any SP of SQL I suggest to update it first and than do SQL.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn about cloud computing and its benefits for small business owners.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question