How to install TFS2008 with SQLSERVER 2008SP1-优快云博客

本文介绍如何在已安装SQLServer2008SP1的情况下部署TFS2008，包括整合安装TeamFoundationServer及ServicePack1、修改hcpackage.xml文件的具体步骤，并提及了为何需要单独安装WSS。

To Install TFS2008 with SQL Server 2008, it is needed to Integrate the Installation of Team Foundation Server and Service Pack 1 first. After TFS2008SP1 has been installed, you can upgrade SQL Server2008 to SQL Server2008 SP1, and it will work well.

For this scenario: SQL Server2008 SP1 has been already installed, how to install TFS2008?

1. Integrate the Installation of Team Foundation Server and Service Pack 1

2. Modify hcpackage.xml in setup folder.( http://support.microsoft.com/kb/969985)

1) Find the following entry:

a. <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" />

2) Replace the entry that you found in step 6 with the following entry:

3) Find the following entry:

a. <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" />

4) Replace the entry that you found in step 8 with the following entry:

a. <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" />

5) Find the following entry:

a. <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.1" />

6) Replace the entry that you found in step 10 with the following entry:

a. <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.2" />

3. Install WSS ("wcu"WSS" InstallSharePoint3.exe)

4. Bind the IIS site "Sharepoint Central Administration V3" to port "17012"

The default port of this site is random, you can also use ConfigureConnetions Command to change the Sharepoint Site Url of TFS after installation.

5. Install TFS2008 SP1 as normal.

The reason why it is needed to install WSS separately is that TFS2008 SP1 cannot install it correctly with SQL Server2008 SP1.(I tried twice)

转载于:https://www.cnblogs.com/Ruiz/archive/2009/09/21/1570987.html