TFS Migration Upgrade – “Scale-Out” Reporting Services issues

Last Friday I started a long upgrade process to migrate from an old TFS 2005 environment to the latest and greatest: TFS 2013 Update 3 RC. As you know, upgrading from TFS 2005 to TFS 2013 is only possible via an intermediate upgrade to TFS 2010. Both upgrades were full migration upgrades to make use of new hardware. One important note here: make sure you still use Windows Server 2008 R2 to setup the TFS 2010 environment. TFS 2010 is not supported on Windows Server 2012!

image

Anyway, during both migration upgrades, I ended up with a “Reporting” error during the verification process in the upgrade wizard.

image

Having done many upgrades before, I immediately had an idea what went wrong and checked the Scale-Out Deployment configuration in SQL Reporting Services.

image

image

By doing a full migration upgrade (Data Tier + Application Tier), the “old” TFS server (TFS-02) was still joined and blocked the verification process for the Reporting feature in the TFS Upgrade Wizard.

Removing the Server from the UI generates an error, so you need to open up a command prompt to complete this removal process.

image

Use the rskeyMgmt list command and provide the SQL Server instance name if you did not use the default one (MSSQLSERVER). This command will return the guid of the “new” and “old” Report Servers.

image

Copy the “old” guid and use that string to paste it into the rsKeyMgmt remove command.

image

All green now!

image

Would love to see this workaround pop up in the TFS Installation Guide for a TFS Migration upgrade.

All’s well that ends well!

image

One Response to TFS Migration Upgrade – “Scale-Out” Reporting Services issues

  1. Scott Munro says:

    Don’t forget to run RSKeyMgmt in an elevated command prompt. I got ‘Access Denied’ errors to begin with.
    http://social.msdn.microsoft.com/Forums/en-US/e6279c3c-8620-41ad-b6f6-6122c509ecc9/duplicate-scaleout-entries-sql-2008-r2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: