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

Posted on 2007-07-23
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
    LVL 12

    Expert Comment


    TFS is not dependent on SQL SP installation.

    Author Comment

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now