After days on contemplation of whether to install the Team Foundation Server Beta on anything other than a VPC I decided to load it on my laptop. Apparently, the list of prerequisites seems quite… long. I had SQL server 2005 with Analysis and Reporting Services already installed when the Installer prompted an error saying I don’t meet the Pre-requisites.
Out of the list that were missing on my laptop, WSPS, WSPS SP1, Reporting Service and Analysis Service were the primary items. WSPS and WSPS SP1 missing errors were relatively easy to fix by downloading the WSPS and WSPS SP1 from the Microsoft Site. Then came the part where you start doubting if it’s going to be worth spending hours in something that has no guarantee of working.
After countless number of uninstalls and installs it just wouldn’t detect my Reporting Server and Analysis Service. After hours of googling and reading up blogs it turns out that the SQL server Reporting Service and Analysis Service has to be installed on the default database instance and NOT on a named instance. Hmm… Easy when you know the answer! I just Ran the SQL Server 2005 installer and installed Reporting and Analysis service on the default instance. 6 hours of my life wasted fixing nothing - price paid for not reading the documentation :)