TFS - \'TF220066\' error on TFS 2008 install

If your SQL version is 2008 R2 and TFS you are trying to install is TFS 2008, you have to integrate the Service Pack 1 for TFS 2008 with the installation files and then run the TFS 2008 installation. This i because, at the time of TFS 2008 release, SQL 2008 was not yet released, the support for SQl 2008 was introduced only with the SP1 release of TFS 2008.

The instructions on integrating the Sp1 with the TFS 2008 installation media is detailed in the TFS install guide for 2008 under section: "How to: Integrate the Installation of Team Foundation Server and Service Pack 1".

---

如何安装可视的 Microsoft Studio 2008 团队基础服务器上已安装的 SQL Server 2008 Service Pack 1 的计算机

若要解决此问题，请按照下列步骤操作：

1. 从下面的 Microsoft 网站下载 Microsoft Visual Studio 2008 团队基础服务器 Service Pack 1：
   http://www.microsoft.com/downloads/details.aspx?FamilyId=9E40A5B6-DA41-43A2-A06D-3CEE196BFE3D
2. 团队基础安装指南下载 Microsoft Visual Studio 团队系统 2008年用于从下面的 Microsoft 网站：
   http://www.microsoft.com/downloads/details.aspx?FamilyID=FF12844F-398C-4FE9-8B0D-9E84181D9923&displaylang=en
3. 在步骤 2 中下载了安装指南中，请按照所述的前五个步骤在"如何： 集成团队的安装基础服务器和 Service Pack 1"主题。
   
   注意若要本主题展开左窗格的安装指南中的 安装团队基础服务器和 Service Pack 1。
4. 打开您在步骤 4 中创建的 C:\MergeFolder 文件夹在"如何： 集成团队的安装基础服务器和 Service Pack 1"主题。
5. 通过使用记事本打开 Hcpackage.xml 文件。
6. 查找以下项：
   <WQL * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' PropertyName='VERSION' AND PropertyStrValue AND &gt; ='10.00.1433' AND PropertyStrValue LIKE '10.00.%'"
7. 替换您在步骤 6 使用以下项中找到的项：
   <WQL * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' PropertyName='VERSION' AND PropertyStrValue AND &gt; ='10.00.1433' AND PropertyStrValue LIKE '10.%'"
8. 查找以下项：
   <WQL * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' PropertyName='VERSION' AND PropertyStrValue AND &gt; ='10.0.1433' AND PropertyStrValue LIKE '10.0.%'"
9. 替换您在第 8 步用下面的项中找到的项：
   <WQL * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]' PropertyName='VERSION' AND PropertyStrValue AND &gt; ='10.0.1433' AND PropertyStrValue LIKE '10.%'"
10. 查找以下项：
    <MsiProductVersionCheck prodid ="[%SQLServer2008 %]"操作 ="&lt;"version="10.1"/
11. 替换在具有以下项的第 10 步中找到的项：
    <MsiProductVersionCheck prodid ="[%SQLServer2008 %]"操作 ="&lt;"version="10.2"/
12. 保存 Hcpackage.xml 文件。
13. 运行 sp1 安装 Visual Studio 2008 团队基础服务器的 Setup.exe。

---

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

这是上面的第2步

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the local computer.

To integrate the installation of Team Foundation Server and Service Pack 1

1. Download SP1 from the Microsoft Web site, and save the update to a folder on the local computer.

   For example, you can save the file to C:\SP1Download.

2. From the files that originated on the DVD for Team Foundation Server, copy the AT folder to a location on the local computer.

   For example, you can copy the folder to C:\InstallMedia.

3. On the local computer, right-click the AT folder, click Properties, and then clear the Read-only check box.

4. Open a Command Prompt window, and type the following command, replacing C:\SP1Download with the location that you chose in step 1 and C:\SP1Extract with a separate location on the local computer:

   C:\SP1Download\TFS90SP1-KB949786-ENU /extract:C:\SP1Extract

5. Create a folder where you can merge files from SP1 and the DVD.

6. Type the following command, replacing C:\InstallMedia with the location that you chose in step 2, C:\SP1Extract with the location that you chose in step 3, and C:\MergeFolder with the absolute path of the location that you chose in step 4:

   msiexec /a C:\InstallMedia\AT\vs_setup.msi /p C:\SP1Extract\TFS90sp1-KB949786.msp TARGETDIR=C:\MergeFolder

   Note:
   You must replace C:\MergeFolder with an absolute path, but you can replace C:\InstallMedia and C:\SP1Extract with absolute or relative paths.

7. From C:\MergeFolder (which you created in step 4), run setup.exe to install Team Foundation Server with SP1.