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>='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>='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>='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>='10.0.1433' AND PropertyStrValue LIKE '10.%'" action="=" count="0" />
Find the following entry: (Search for %SQLServer2008% )
<MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" version="10.1" />
Replace with:
<MsiProductVersionCheck prodid="[%SQLServer2008%]" action="<" 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