“}Inspired by TFS 2008 features i was waiting to attend the training. Luckily Microsoft had arranged a Free Training with HOL for June 2008. I registered it and luckily manage to get the seat. I attended the training and cant wait to have a TFS server installation VPC on my own. So i planned to get my own VPC for TFS 2008.
I started with the old VPC which has MOSS 2007 with the domain controller. Before installing the TFS server i read the installation guide that comes with the TFS server installer. The below are the mandatory requirement
- SQL 2008 or SQL 2005 with SP2
- Analysis Services of any of the SQL server
- Reporting Services of any of the SQL server
- WSS 3.0 (installed) it will be installed by TFS Server 2008
- TCP IP port needs to be enabled for SQL Server
- SQL Server Agent service should be started
- Please avoid Named Instance for SQL server installation if you have a choice to use default instance for SQL. I struggled a lot for named instance
- Cannot install on Domain Controller.
I uninstalled MOSS 2007 from my VPC which removed WSS also. Now i am ready to remove the domain. I ran the DCpromo command and removed the domain from the windows 2003 server.
Now my VPC is in Workgroup which is ready for SQL installation. To install SQL 2005 standard edition i had to wait for 3 days because my IT people was not around he will be back only on Monday (22/06/09). I cant wait on weekends so i downloaded the SQL 2008 enterprise edition trial version. I installed it on Saturday (20/06/09). SQL 2008 installation looks entirely different. It asks me account password for the services and full text search is not default installation option. So i installed without Full Text Search. I installed with named instance. The server agent also set to manual start. With SQL 2008 installed successfully i tried to install TFS 2008.
When i ran the scan for TFS 2008, it throws me soo many exception. SQL Full Text search is a mandatory option. So i had to run the setup again to add the feature. After the successful installation rescan of TFS didn’t recognize Analysis services for 2008. I googled it and found that named instance is a problem need to add a server name in the msiproperty.ini. I added the server name in TFSASInstance but still didn’t recognize the analysis services. So uninstalled the SQL 2008 completely and had to reinstall with default instance. I reinstalled SQL 2008 again and now the TFS scan gives me error on permission to the DB. I used the Local Service account for the SQL services, it didnt work for current user(Admin) even though it was a sysadmin. So i changed the service acc to current Installation account (Admin). Now i ran the rescan of TFS again, i got only two warning and allowed me to proceed. When i proceed to the last, it asks me to install WSS3.0. I installed the WSS3.0 and finally the installation failed with corrupted setup file.
I had to download the installer again from Microsoft site. This time i downloaded without download manager and ran the installer setup. This time finally i succeeded in installation.
Senthamil 
SQL 2008 will need SP1. , if tou are going to Use Named Instance then try to name ur Analysis Service also as a named instance(same). then suppose it will work, Another problem was that if you website has any Custom Header then ur installation will fail,While installing u need two user accounts in the work group .one for installing and another one for running the service. TFS wont allow the user which was used to run the installer to be same as the once running the service.If Share point service is on another machine then u need to install the Share point extensions there first before starting the TFS install.
Thanks