Deploying Team Foundation Server 2008 on Windows Server 2008 Dual Server Deployment / Installing Team Foundation Server 2008 on Windows Server 2008 Dual Server Deployment

Team Foundation Server 2008-Dual Server deployment

App layer: Windows Server 2008 Standard Edition [TFS 2008 with SP1 only runs on x86] with SP1. (Patched up-to-date) (Vmware virtual machine)
Server name: lab-tfs-app1
Software: SSRS 2008 (A component of Microsoft SQL 2008 Standard Edition with SP1) with SP1, WSS3 with SP2 (The steps below will guide you through those installations)

Data layer: Windows Server 2008 Standard Edition [x86 or x64] with SP1. (Patched up-to-date) (Vmware virtual machine)
Server name: lab-tfs-db1
Software: Microsoft SQL 2008 Standard Edition with SP1

Both servers are new and has been only altered a little bit:
Firewall: OFF
UAC: OFF (msconfig.exe)
DEP: OFF

This wizard guides you through the steps when deploying TFS 2008 with SP1 on two servers, a TFS 2008 Dual Server Deployment.

The app later will contain the SSRS and WSS components.
The app and data layer servers are fresh installs. The data layer software (MSSQL 2008) installation is brand new.

###################################################
User account creation and user right configuration.
###################################################
Create service accounts in Active Directory

TFSSETUP
Used to install Team Foundation Server.
This account must be an administrator on Team Foundation app layer and data layer servers.

TFSSERVICE
Used as the service account by Windows services for Team Foundation Server and SSRS.
Used as the identity of the Microsoft Team Foundation Server Application Pool and SSRS.
-Logon as a service on app layer
-Logon locally on app layer
-In ADUC, check “Account is sensitive and cannot be delegated” on the user object.

Add TFSSETUP as local Administrator on app layer and data layer servers.

On app layer open a command prompt and type secpol.msc and press ENTER for starting “Local Security Policy” MMC.

Local policies/User right assignment:
Allow log on locally for TFSSERVICE
Log on as a service for TFSSERVICE

Log out from both app layer and data layer.
From now on. Log only in with TFSSETUP.

###############################################
Installing prerequisites for application layer:
###############################################

Install IIS7.

Create a .BAT file. Fill it with:

ServerManagerCmd -install Web-Server
ServerManagerCmd -install Web-Http-Redirect
ServerManagerCmd -install Web-Asp-Net
ServerManagerCmd -install Web-Windows-Auth
ServerManagerCmd -install Web-Mgmt-Compat
Pause

Execute it on the app layer server.

Installation of IIS7 is complete.

###################################################
Slipstream TFS 2008 SP1 into TFS 2008 install media
###################################################

Integrate the Installation of Team Foundation Server and Service Pack 1

On the app layer create the following folders:

C:\temp\TFS\SP1Download
C:\temp\TFS\InstallMedia
C:\temp\TFS\SP1Extract
C:\temp\TFS\MergeFolder

Download TFS 2008 Sp1 from:

http://www.microsoft.com/downloads/details.aspx?familyid=9E40A5B6-DA41-43A2-A06D-3CEE196BFE3D&displaylang=en

Move it to C:\Temp\TFS\SP1Download

Create a .BAT file. Fill it with: (Please alter the x:\ below to reflect your location of the TFS 2008 installmedia))

C:\temp\TFS\SP1Download\TFS90SP1-KB949786-ENU /extract:C:\temp\TFS\SP1Extract
xcopy x:\at\*.* C:\temp\TFS\InstallMedia /D/E/F/Y/H
msiexec /a C:\temp\TFS\InstallMedia\vs_setup.msi /p C:\temp\TFS\SP1Extract\TFS90sp1-KB949786.msp TARGETDIR=C:\temp\TFS\MergeFolder
Rename C:\temp\TFS\MergeFolder TFS2008_With_SP1
attrib c:\temp\TFS\TFS2008_With_SP1 -R -S -H /S /D
pause

*************************************************************************************************************************************
Preconfig the Hcpackage.xml
The TFS 2008 with SP1 installation fails if you install it against a data layer running SQL Server 2008 SP1. The TFS installation does not recognize that new version of SQL…
To solve that you have follow these steps:

Either download a pre-hacked Hcpackage.xml from www.postmaster.se/download/tfs and replace the one in c:\temp\TFS\TFS2008_With_SP1.

O R do the search and replace yourself:

Backup c:\temp\TFS\TFS2008_With_SP1\Hcpackage.xml
Open c:\temp\TFS\TFS2008_With_SP1\Hcpackage.xml by using Notepad.
**********************************************************************************************************************************************************************************************************************************************************************************************
Find the following entry: (Search for 10.00.% )
<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″ />

Replace with:

<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″ />
**********************************************************************************************************************************************************************************************************************************************************************************************
**********************************************************************************************************************************************************************************************************************************************************************************************
Find the following entry: (Search for 10.0.% )
<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″ />

Replace with:

<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″ />
**********************************************************************************************************************************************************************************************************************************************************************************************
**********************************************************************************
Find the following entry: (Search for %SQLServer2008% )

<MsiProductVersionCheck prodid=”[%SQLServer2008%]” action=”&lt;” version=”10.1″ />

Replace with:

<MsiProductVersionCheck prodid=”[%SQLServer2008%]” action=”&lt;” version=”10.2″ />
**********************************************************************************
Save the Hcpackage.xml file.
########################################
Installing SQL Server 2008 on data layer
########################################
Log on to data layer using TFSSETUP

Note:
The installation program for SQL Server offers to install the appropriate versions of the Microsoft .NET Framework and Windows Installer if they are not already installed.
You MUST install these components to proceed with the installation of SQL Server, and you must restart your server when prompted after these components are installed.

On the SQL Server Installation Center page, click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.

On the Setup Support Rules page, click OK.
On the Product Key page, type your product key.
On the License Terms page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms check box, and then click Next.
On the Setup Support Files page, click Install.
On the Setup Support Rules page, click Next.
On the Feature Selection page, select the check boxes for the following components, and then click Next:

Database Engine Services

Full-Text search

Analysis Services

Management Tools - Basic

On the Server Configuration page, click Use the same account for all SQL Server services, or type the name of a domain account or
NT AUTHORITY\NETWORK SERVICE in Account Name for every service.

In the Startup Type column, verify that Automatic appears for all accounts that you can edit, and then click Next.

!!Make sure to use the Latin1_General_CI_AS collation, which is “hidden” in an optional tab in the new installation dialog wizard. (Latin1_General_CI_AS collation är standard på engelska OS, men inte om du valt svenska inställningar under OS-installationen.)

On the Database Engine Configuration page, click Windows authentication mode, click Add Current User, and then click Next.

On the Analysis Services Configuration page, click Add Current User, and then click Next.

After the installation is complete, apply SQL 2008 SP1.
Open SQL Server Management Studio and verify that all services are running.
Open a command prompt and type “cliconfg”
Activate TCP/IP.
######################################################################
Installing SQL Server 2008 Reporting Services on the application layer
######################################################################
The installation program for SQL Server offers to install the appropriate versions of the Microsoft .NET Framework and Windows Installer
if they are not already installed. You MUST install these components to proceed with the installation of SQL Server, and you must restart
your server when prompted after these components are installed.
Install the components above and reboot.
After reboot start the SQL 2008 x86 install program.

On the SQL Server Installation Center page, click Installation, and then click New SQL Server stand-alone installation or add features
to an existing installation.

On the Setup Support Rules page, click OK.
On the Product Key page, type your product key.
On the License Terms page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms check box, and then click Next.
On the Setup Support Files page, click Install.
On the Setup Support Rules page, click Next.
On the Feature Selection page, select the check boxes for the following components, and then click Next:

Database Engine Services

Reporting Services

Management Tools - Basic

Use NT AUTHORITY\NETWORK SERVICE in Account Name for every service.
Set all services to Automatic start up.
Make sure to use the Latin1_General_CI_AS collation, which is “hidden” in an optional tab in the new installation dialog wizard

!!Choose “Install, but do not configure the report server”
Apply SQL 2008 SP1.
#######################################################################
Configuring SQL Server 2008 Reporting Services on the application layer
#######################################################################
Run Reporting Services Configuration Manager. (Command prompt (RSConfigTool.exe))
Service account: TFSSERVICE
Web Service URL: Click Apply
Database: Change database. Create a new Report Server database
Database server:  the data layer server.
Report Server Mode: Native Mode
Report Manager URL: Click Apply
Verify that all SSRS URL’s are accessible and exit the RSConfigTool
#######################################################################
Installing Windows Sharepoint Services 3.5 SP1 on the application layer
#######################################################################
Download Windows SharePoint Services 3.0 with Service Pack 2 from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=ef93e453-75f1-45df-8c6f-4565e8549c2a&displaylang=en

Run Sharepoint.exe
Choose the installation you want: Advanced
Next form choose “Web Front End…” and click “Install now”
After installation is complete run “SharePoint Products and Technologies Configuration” Wizard (under Windows Administrative Tools)

First form: No, I want to create a new server farm.
Database server: Enter the name of the data layer server.
Specify database access account: ad_domain_netbios_name\TFSSERVICE where ad_domain_netbios_name is your AD domain.
Specify port number: 17012
Choose an authentication provider: NTLM
Fill a .BAT file with:

cd “c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\”
pause
stsadm.exe -o extendvs -exclusivelyusentlm -url http://%COMPUTERNAME%:80 -ownerlogin %USERDOMAIN%\TFSSERVICE -owneremail “admin@localhost” -sitetemplate sts -description “Default Web Site”
stsadm.exe -o siteowner -url http://%COMPUTERNAME%:80 -secondarylogin %USERDOMAIN%\%USERNAME%
pause
iisreset /noforce

Check the quotation mark format and replace if necessary.
Please alter that file to reflect your installation environment
Path of “c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\” that path should be the one that leads to stsadm.exe
%USERDOMAIN% = Your Active Directory NetBIOS name.
%COMPUTERNAME% = The app layer server
TFSSERVICE = The TFS service account. Normally TFSSERVICE
%USERNAME% = TFSSETUP
Execute it.

Verify that you can access SharePoint 3.0 Central Administration (This guide http://lab-tfs-app1:17012) and the extended Default Web Site above. (This guide http://lab-tfs-app1:80 )

##################################################################################
Installing Team Foundation Server 2008 with SP1 integrated on the application layer
###################################################################################
!Database server that hosts the TFS database should be the data layer server.
TFS setup verifies the installation environment. Please fix all varnings and errors. If VM there is a warning regaring hardware requirements. If firewall off, also warning.

Administrative URL: http://%COMPUTERNAME%:17012 (http://lab-tfs-app1:17012)
WSS URL: http://%COMPUTERNAME%:80/Sites (http://lab-tfs-app1:80/Sites)

When installation is complete (without errors) download TFS 2008 Power Tools (http://www.microsoft.com/downloads/details.aspx?FamilyId=FBD14EEA-781F-45A1-8C46-9F6BA2F68BF0&displaylang=en)
Run the TFS 2008 Best Practices Analyzer. Do a health check. If Vm, the only warning should be regarding the hardware requrements, else if clean.

Michael Folin
Systems Engineer
MCSE MCSA MCSA Messaging
http://www.folin.se/
michael@postmaster.se