每日点滴之贰零零玖年拾壹月贰日

成功安装TFS：

Windows Server 2003 SP2

IIS 6.0

SQL Server 2008 SP1（Enterprise Edition）

TFS SP1(集成包)，参考http://www.woodwardweb.com/vsts/creating_a_tfs.html

在安装TFS发生SQL Server版本不兼容的错误，参考了http://blogs.msdn.com/rextang/archive/2009/05/19/9625393.aspx，修改了安装目录AT下的 Hcpackage.xml，问题解决。

摘录如下：

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&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:

<WQL namespace="\\.\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:

<WQL namespace="\\.\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:

<WQL namespace="\\.\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" />

过程相对来说比较顺利，明天进行配置。