VS2008 Team Foundation Server + SQL 2005 SP4 + Windows 2008

VS2008 Team Foundation Server + SQL 2005 SP4 + Windows 2008 I spent two days of weekend with a lot of problems when install TFS 2008 on Windows Server 2008 with SQL Server 2005 SP4 for my company. Luckily, I installed the server as virtual machine by using Hyper-V on a “real Windows Server 2008 Enterprise x64″ so I could reverse everything and started over when I got problems by Snapshot function :-)

It’s good for my experiences! I want to share with everybody who will do so.
Do not install any automatic update during the installation progress.
You have to follow exactly the order of the steps below if you don’t want to get any problem ;-)

Steps to install Team Founddation Server 2008:

  1. Install Windows Server 2008 Standard with IIS 7.0 and the NET Framework 3.5 SP1 and verify it works :-)
  2. Install SQL Server 2005 with full services and components: Server components, the Client components, the Reporting Services, Full-text search, Analysis services and the Management Studio…
    NOTE: – Remember to reboot the machine after the installation and verify the server is running by connecting with the Management Studio. Don’t configure the Reporting Services, this step will be done by TFS.
    - Using SQL Server Configuration Manager to config SQL Server 2005 Network Configuration: Select Protocols for MSSQLSERVER. Enable following protocol: Shared Memory, Named Pipes, TCP/IP
  3. Install SQL Server 2005 SP4
  4. Create an windows account with administrative rights, name: “TFS” as TFS administrator
  5. Download Windows SharePoint Services 3.0 with SP2 from here:http://www.microsoft.com/downloads/en/details.aspx?FamilyId=EF93E453-75F1-45DF-8C6F-4565E8549C2A&displaylang=en
    - Run the setup file and choose the advanced installation. You have to choose the front-end installation.
    - After the installation is done, choose to create a new server farm, then choose the local server name, leave the database name as is, and with this syntax domain\user provide the credential for the TFS administrator user. Check the box for the port, don’t use the suggested port and take a note of the port you will use (ex: xxxxx), then choose the NTLM authentication.
    - Check your settings and after you take a note of everything proceed with the configuration of WSS. It will take a while!
    - Now we need to play with the DOS :-) First open prompt and change directory to: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\
    - What’re the below commands meant? The first will be granted the administrator of SharePoint, the second one is the admin account for TFS. I use the same account …
    - Copy-paste-modify and run this command: stsadm.exe -o extendvs -exclusivelyusentlm -url http://YourServerMachineName:80 -ownerlogin YourServerMachineName\TFS -owneremail “admin@localhost” -sitetemplate sts -description “Default Web Site”
    - Copy-paste-modify and run this command: stsadm.exe -o siteowner -url http://YourServerMachineName:80 -secondarylogin YourServerMachineName\TFS
    - Go to Central Administration (http://YourServerMachineName:xxxx) – did you take note the port number?. Login by the TFS account, go to Site Actions – Site Settings, under User and Permissions, click on Site Collection Administrators then add the TFS account to the collection. In Advanced Permission, click New – Add User then add the TFS account with Full Control permission.
    - Go to WSS (http://YourServerMachineName). Login by the TFS account, go to Site Actions – Site Settings, under User and Permissions, click on Site Collection Administrators then add the Administrator account to the collection. In Advanced Permission, click New – Add User then add the Administrator account with Full Control permission.
  6. Install step by step Team Foundation Server 2008:
    - Let’s install the TFS server. Choose the database server (local machine name) and go ahead.
    - Configure the account for TFS and SQL Reporting Service by using TFS administrator account.
    - Choose the previous WSS Central Administration address and site (did you take note of the port??)
    - You are almost done! :-)
  7. Install Visual Studio Team System 2008
  8. Install Team Explorer 2008
  9. Install Visual Studio 2008 SP1
  10. Install TFS 2008 SP1
  11. Install TFS 2008 Web Access with SP1 (http://www.microsoft.com/downloads/en/details.aspx?familyid=3ecd00ba-972b-4120-a8d5-3d38311893de&displaylang=en)
  12. Install TFS 2008 Power Tools (http://www.microsoft.com/downloads/en/details.aspx?FamilyId=FBD14EEA-781F-45A1-8C46-9F6BA2F68BF0&displaylang=en)

Good luck!

HuyNT

Social Bookmarks

Comments

View comments (0)
Send your comment about this article