TFS 2008 upgrade process

After using Team Foundation Server (TFS) 2005 for a few months now, we recently ran into the well - documented merge bug: "TF14087: Cannot undelete 'filename here' because not all of the deletion is being undeleted.". This was the second it happened to us, and resolving this conflict is quite difficult (More info about this issue). We found a hotfix that might fix the problem, but since we were about ready to upgrade to VS 2008 and TFS 2008 supposedly provided a lot of improvements around merging, we decided to go ahead and upgrade TFS to the latest version. (note: supposedly VS 2008 works fine with TFS 2005 - unless you absolutely need the upgrade, I'd recommend sticking to 2005 until you can free up a few days dedicated to the TFS upgrade).

After reading the install guide and following to the letter, I started the install process. Sure enough, I ran into the following obscure 32000 error:

The Commandline '"C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Tools\TFRSConfig.exe" /setup /install /s "servername" /u "NT Authority\NetworkService" /buildInIdentity /l "1033" /verify /ignoreExistingIISArtifacts /instancename "MSSQLSERVER" /appPoolName "ReportServer" /reportServerUri "http://oceg2/ReportServer" /reportManagerUri "http://oceg2/Reports" /h "servername"' returned non-zero value: -2147022676.

I looked it up, found a couple of posts about similar issue, but no real answer. Looked at the install logs (%Temp%/VSMsiLog****.txt), and found this:

Deleting virtual directory Reports for Report Manager...Deleting virtual directory ReportServer for Report Server...Deleting application pool ReportServer...
Creating application pool ReportServer...
Creating virtual directory Reports for Report Manager...
Configuring Report Manager virtual directory Reports to use application pool ReportServer...Error: 2147944620.Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesWmiException: Exception of type 'Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesWmiException' was thrown. at Microsoft.TeamFoundation.Admin.ReportingServices.WMIManagementObjectWrapper.PostProcessResult(ManagementBaseObject resultObject) at Microsoft.TeamFoundation.Admin.ReportingServices.WMIManagementObjectWrapper.InvokeWmiMethod(String methodName, Dictionary`2 parameters, String resultKey) at Microsoft.TeamFoundation.Admin.ReportingServices.ReportServerWmi.SetReportManagerIdentity(String appPoolName) at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.ConfigureWebServiceArtifacts() at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.Run() at Microsoft.TeamFoundation.Admin.ReportingServices.Program.Main(String args)
Configuring SQL Server Reporting Services failed.

After fighting with this problem for 4 hours, I gave up and used one of my free MS tech support incidents. I was told by the first person I talked to that TFS 2008 was still in beta (this is as Jan 7th 2008), and therefore the product was supported (??? - TFS 2008 was released with VS 2008 late Nov). After arguing for 5 minutes and speaking to a manager, they redirected me to the VS 2008 install tech support team.

One hour on the phone later, the VS guy told me the issue had to do with my Reporting Services install, so he'd need to get me in touch with the Reporting Services team. I then spent the rest of my day (another 7 hours - I'm not exaggerating) on the phone with that person. By the end of our call, she couldn't figure it out, we had made absolutely no progress and we had to reschedule our call to the next day. I did manage to get this gem though: "You're not the only one with this problem, it happens from time to time, but we usually have a hack around it by bypassing the RS configuration manager and setting the application pool directly in IIS. It looks like TFS assumes Reporting Services can successfully configure itself, which it often can't". Nice one.

So after an 8 hour phone call and another 1/2 day wasted on this thing, I was stuck with a broken TFS install (nothing was working at this point, not even the old version). I gave up on MS and went back at it myself - couldn't spend another day on the phone and see no result whatsoever.

I uninstalled SQL Server Reporting Services, re-installed it, re-applied SQL Server SP1, and re-configured the new instance. Tried re-installing TFS 2008, and everything worked smoothly until... a new error came up, asking me to check my SharePoint/IIS/ASP.NET config settings. I messed with this for about 90 minutes, then decided to re-install SharePoint. I uninstalled SharePoint 2.0, downloaded 3.0 with SP1 and installed that. Of course, I hadn't read the part of the TFS install guide that says "install SharePoint as a web farm", so it didn't work. Uninstalled and re-installed, this time following the directions to the letter.

This time - lo and behold - it worked and upgraded my existing projects successfully. I can connect VS 2008 to my new TFS install, everything works fine. And yes, the merge error is gone, I was able to successfully merge all my branches.

So, long story short, if you're about to upgrade TFS from 2005 to 2008:

• Prepare yourself for a major headache.
• Read the install guide to the letter. Take a break. Read it again. Every word of it.
• If reporting services cause problems, don't waste your time trying to fix it. Even MS Tier 1 tech support engineers couldn't fix this problem. Just re-install the damn thing. And if like me you experience the "SQL Server Backward Compatibility" error and you're running SP1, repair it by using "SQLServer2005_BC.msi" that gets extracted during the SP1 install. It's abit tricky since that file can only be found during the SP1 install - the installer gets rid of the install folder at the end of the installation.
• If you're having SharePoint issues and you're only using SharePoint for TFS (which was the case here) - same thing, just re-install and remember to choose "advnaced install" and configure your installation as a web farm. TFS 2008 supports SharePoint 3.0, so you might as well upgrade.
  

I hope this post will save somebody the pain I've just been through.