TFS2010 Application Tier Only Wizard Fails during preparing server databases

Recently, in one of my customer’s case I have seen an issue in which the TFS2010 application tier only wizard fails while creating the server databases with below error message: An exception was occurred while creating the server databases. The exception message is “TfsMasterCreateSchema.sql Line 145 Error: Invalid object name ‘dbAdmin.dbo.changelog’” When I went through…


TFS stored procedure and other TFS related SQL calls might fail during TFS Configuration if the query governor is enabled and has a low threshold defined in it.

  Problem Description:- I came across a customer who is not able to configure TFS correctly because TFS Configuration database would fail to create. We looked in the profiler trace and we are seeing the SQL server throwing the following error while TFS tries to configure the configuration db: “The query has been canceled because…


Frequently used commands during TFS 2010 troubleshooting

  In CSS we regularly use a variety of command line tools for troubleshooting and maintenance of Team Foundation Server (TFS) and related technologies. This post provides a grouping of the most frequently used command which TFS administrators should keep handy with them. We do look forward to feedback from the community to add more…


TFS 200x to TFS 2010 upgrade: SharePoint project portal decision

  This had been lying in my kitty for a long time now. Since the time I blogged about the various TFS upgrade paths (Migration, In-Place and Import), I have been asked about the SharePoint and SQL Reporting Services upgrade paths that should be considered before actually performing any one of the above mentioned TFS…