Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×