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.
To resolve this issue, follow these steps:
- Download Microsoft Visual Studio 2008 Team Foundation Server Service Pack 1 from the following Microsoft Web site:
- Download the Team Foundation Installation Guide for Microsoft Visual Studio Team System 2008 from the following Microsoft Web site:
- 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. - 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.
- Open the Hcpackage.xml file by using Notepad.
- 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"
/>
- 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"
/>
- 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"
/>
- 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"
/>
- Find the following entry:
<MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.1" />
- Replace the entry that you found in step 10 with the following entry:
<MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.2" />
- Save the Hcpackage.xml file.
- Run Setup.exe to install Visual Studio 2008 Team Foundation Server with SP1.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
