Adding reporting in TFS 2012 upgrade.

Question

I've been working on a project to upgrade TFS from 2010 to 2012. I've created a new server, setup the databases in SQL 2012 and installed TFS 2012. The core functionality appears to be working fine.

The issue is with reports, it appears reporting was never setup correctly on the original installation (analysis services was not installed), so the TFS reports exist on the old reportserver, but point to a non-existant TFS_Analysis database.

On the new server I created Reporting and Analysis services are installed, and specifying the reports path created all of the reporting folders, but there are no reports. I'm not sure at this point how to get the standard reports installed on the new server. I am open to trying to repair the old server further and then re-upgrading, but I'm not sure if that's possible.

Answer 1

Hi KittH,

Thanks for your post!

When you upgrade from TFS 2010 to TFS 2012, in the Configure Reporting for Team Foundation Server page, have you select the  Configure Reporting for use with Team Foundation Server check box to use reporting?

If not, you may need to use different database names for the reporting warehouse databases (TFS_Warehouse and TFS_Analysis). As an alternative, you can delete the old reporting databases and new databases will be created using the default names.

For more information, please refer to TFS 2012 installation guide, amd the following thread:

http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/f3115fac-3f0a-4314-96ac-06355aad15f0

Hope it helps!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi KittH,

Is the issue solved? I am marking the reply as answer, if you have any concern with it, please feel free to unmark it.

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us