How to install TFS2008 with SQLSERVER 2008SP1

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&gt;='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:

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

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&gt;='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&gt;='10.0.1433' AND PropertyStrValue LIKE '10.%'" action="=" count="0" />

5)    Find the following entry:

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

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

a.     <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="&lt;" 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)