You are currently offline, waiting for your internet to reconnect

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:
  2. Download the Team Foundation Installation Guide for Microsoft Visual Studio Team System 2008 from the following Microsoft Web site:
  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:
    <WQLnamespace="\\.\root\Microsoft\SqlServer\ComputerManagement10"query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue&gt;='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:
    <WQLnamespace="\\.\root\Microsoft\SqlServer\ComputerManagement10"query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue&gt;='10.00.1433' AND PropertyStrValue LIKE '10.%'"action="="count="0"/>
  8. Find the following entry:
    <WQLnamespace="\\.\root\Microsoft\SqlServer\ComputerManagement10"query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue&gt;='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:
    <WQLnamespace="\\.\root\Microsoft\SqlServer\ComputerManagement10"query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' AND PropertyName='VERSION' AND PropertyStrValue&gt;='10.0.1433' AND PropertyStrValue LIKE '10.%'"action="="count="0"/>
  10. Find the following entry:
    <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="&lt;" version="10.1" />
  11. Replace the entry that you found in step 10 with the following entry:
    <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="&lt;" 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.
Properties

Article ID: 969985 - Last Review: 06/21/2014 12:54:00 - Revision: 3.0

Microsoft Visual Studio Team System 2008 Team Foundation Server Service Pack 1, Microsoft SQL Server 2008 Service Pack 1

  • kbhowto kbtshoot kbprb kbexpertiseinter kbsurveynew KB969985
Feedback
arAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" tForLargeScreens track by $index" class="col-sm-6 col-xs-24 ng-scope"> Paraguay - Español
Venezuela - Español
id=1&t=">I=4050&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>