KB969985 - How to install Microsoft Visual Studio 2008 Team Foundation Server on a computer that has SQL Server 2008 Service Pack 1 installed

Symptoms

When you try to install Microsoft Visual Studio 2008 Team Foundation Server on a computer that has SQL Server 2008 SP1 installed, the installation fails.

Resolution

To resolve this issue, follow these steps:

  1. Download Microsoft Visual Studio 2008 Team Foundation Server Service Pack 1 from the following Microsoft Web site:

    http://www.microsoft.com/download/details.aspx?FamilyId=9E40A5B6-DA41-43A2-A06D-3CEE196BFE3D

  2. Download the Team Foundation Installation Guide for Microsoft Visual Studio Team System 2008 from the following Microsoft Web site:

    http://www.microsoft.com/download/details.aspx?FamilyID=FF12844F-398C-4FE9-8B0D-9E84181D9923&displaylang=en

  3. In the Installation Guide that you downloaded in step 2, follow the first five steps that are described in the "How to: Integrate the Installation of Team Foundation Server and Service Pack 1" topic.

    Note To find this topic, expand Installing Team Foundation Server and Service Pack 1 in the left pane of the Installation Guide.

  4. Open the C:\MergeFolder folder that you created in step 4 of the "How to: Integrate the Installation of Team Foundation Server and Service Pack 1" topic.

  5. Open the Hcpackage.xml file by using Notepad.

  6. Find the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue>='10.00.1433' AND PropertyStrValue LIKE '10.00.%'" action="=" count="0" />

  7. Replace the entry that you found in step 6 with the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue>='10.00.1433' AND PropertyStrValue LIKE '10.%'" action="=" count="0" />

  8. Find the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue>='10.0.1433' AND PropertyStrValue LIKE '10.0.%'" action="=" count="0" />

  9. Replace the entry that you found in step 8 with the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue>='10.0.1433' AND PropertyStrValue LIKE '10.%'" action="=" count="0" />

  10. Find the following entry:

    <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.1" />

  11. Replace the entry that you found in step 10 with the following entry:

    <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.2" />

  12. Save the Hcpackage.xml file.

  13. Run Setup.exe to install Visual Studio 2008 Team Foundation Server with SP1.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×