I have a basic installation of TFS 2010 running on my Windows 7 laptop. This is really useful for testing build customisation and the like, a great new feature for 2010. Today I got around to trying to upgrade it from RC to RTM, but on the verification test I got the error
[ Configuration Database ] TF255407: An error occurred while attempting to validate the configuration database. Error message: TF246064: No database could be found for the following host: TestCollection. The host has the following ID: eaf3c572-8657-4268-9852-3d73a799cdf5. To fix this problem, use the TFSConfig RemapDBs command-line tool and make sure that you specify the SQL Server instance that contains this database.
Turns out I had been a bit stupid. I had created a couple of test team project collections (TPC) whilst testing some attach/detach scenarios for a client. I deleted the underlying SQL DBs, but not deleted the TCP in TFS, I guess as part of some test, but for the life of me I cannot remember why.
So as the error message suggested I tried to run the TFSConfig command
C:Program FilesMicrosoft Team Foundation Server 2010Tools>tfsconfig remapdbs /sqlinstances:Typhoonsqlexpress /databaseName:typhoonsqlexpress;TFs_configuration
Logging sent to file C:ProgramDataMicrosoftTeam FoundationServer ConfigurationLogsCFG_CFG_AT_0504_090019.log
Command: remapDBs
TfsConfig - Team Foundation Server Configuration Tool
Copyright (c) Microsoft Corporation. All rights reserved.
The Team Foundation Server configuration could not be reconfigured. The following errors were encountered:
TF246064: No database could be found for the following host: test1. The host has the following ID: 4e9b737a-b666-48f4-9411-20249aed7ae0. To fix this problem, use the TFSConfig RemapDBs command-line tool and make sure that you specify the SQL Server instance that contains this database.
TF246064: No database could be found for the following host: TestCollection. The host has the following ID: eaf3c572-8657-4268-9852-3d73a799cdf5. To fix this problem, use the TFSConfig RemapDBs command-line tool and make sure that you specify the SQL Server instance that contains this database.
So the same error as the upgrade wizard. I also tried detaching and deleting the TCP, but got:
C:Program FilesMicrosoft Team Foundation Server 2010Tools>tfsconfig collection /delete /collectionName:TestCollection
Logging sent to file C:ProgramDataMicrosoftTeam FoundationServer ConfigurationLogsCFG_TPC_AT_0504_090828.log
Command: collection
TfsConfig - Team Foundation Server Configuration Tool
Copyright (c) Microsoft Corporation. All rights reserved.
Could not find file ‘C:Program FilesMicrosoft Team Foundation Server 2010Application TierWeb Servicesweb.config’.
But this failed as I had already removed the 2010RC instance, so there was no web.config to read.
So what to do?
I opened SQL Management Studio and connected to my local SQL instance, open the Tfs_Configuration DB and found the tbl_ServiceHost table. I then removed the rows that referenced the TPC that had I deleted the DB for. Of course I had made sure I had a backup of the DB before I started.
Once this was done the upgrade wizard passed verification and completed without error.
Now I would not recommend this as a good way to work, but it did get me out of a hole. In my case it was only a test system so if I lost it, it was not that important. However it is good to know there is a reasonably simple solution address problems with missing TPC DBs
Technical Tip: Make sure all your TPCs are valid before you start the upgrade process, so you don’t see this issue in the first place!