TFS 2010 to TFS 2012 upgrade fails with error in Analysis services

  Recently, I have seen the below issue more frequently in which the TFS 2010 to TFS 2012 upgrade failed due to error in analysis services metadata. Below is the error message which I got: Error: ——- TF255356: The following error occurred when configuring the Team Foundation databases: TF400711: Error occurred while executing servicing step…


Moving .RDL files from one reporting services instance to another

  Scenario: The “.rdl” files have to be moved from one Reporting services instance to another. This scenario arises when the report server database cannot be moved from source to destination SSRS instance, since already a report server database is being used on the target SSRS instance. We will take the test example of the…


Reports icon not showing in Team Explorer everywhere 2012 on eclipse

  Recently, we came across an issue in TEE 2012. Reports node is not displaying after connecting to the TFS 2012 from eclipse. And the reports are showing in Team explorer 2012 for the same user. The root problem is the loss of a permission in new 2012 servers (but not for 2012 servers that…


Changing default location of reports doesn’t show up data on the reports even though the reports are rendered

In Team Foundation Server 2010, for each collection there is a “Current Default Folder Location”. This is where there reports are shown on the Reports Manager page, when a project is created. The location can be either root i.e. “/” or “/FolderA” or “FolderA/Collection1” or “FolderA/FolderB/Collection1” and so on. When a project is created, then…


TF246017: Team Foundation Server could not connect to the database, “Failed to load Msxmlsql.dll".

On a Team Foundation Server instance hosting its Databases on a SQL 2008 R2 instance, If a copy of SQL 2008 Express edition is installed, the Team Foundation Server 2010 might lose connectivity to its SQL database, taking down the whole Team Foundation Server instance. The Team Foundation Server administration console would also be inaccessible….


TFS Config import command fails to upgrade TFS 2008 databases:

Recently, I have worked on a case in which the TFS Config import command fails with below error: Error description ——————- [Error @15:50:30.677] [2012-03-12 21:13:13Z][Error] The event subscriber with SID ‘domain\tfsservice’ is not in Team Foundation. Either add this identity, or delete its subscriptions, then re-run upgrade. [Error @15:50:30.677] [2012-03-12 21:13:13Z][Error] Object reference not set…


TFS 2010 upgrade fails with a custom stored procedure in TFS databases

Recently, I worked on TFS 2008 to TFS 2010 upgrade case and it failed during the project collection servicing with below error: Error message from Collection upgrade log: [Error @20:15:39.558] [2012-04-23 19:58:24Z][Error] schema.tsq Line 38989 Error: Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when…