1

I'm trying to upgrade from TFS2012.2 to TFS2012.3.

I downloaded the ISO, ran the tfs_server.exe, and after a few reboots, I'm prompted with the Upgrade Wizard.

On step two(2) "Specify a Team Foundation Server configuration database to upgrade", I need to specify a SQL Server Instance. But when I click "List Available Databases", no database shows up in the list.

I tried different combinations of SQL Server Instance (servername, servername.domain, ., (local)) but all of them returns an empty list. Note SQL is not running named instance.

SQL is up and running and I can see the TFS databases (Tfs_Configuration, Tfs_DefaultCollection, Tfs_Warehouse).

Everything is running on this one machine.

Digging deeper, in the Event Logs (Team Foundation Server Build Service Events), I found this:

Exception Message: TF400686: The requested schema property TFS_SCHEMA_VERSION did not match the expected value. The server requires the Microsoft Team Foundation Server 2012 M49 schema but the database currently implements Microsoft Team Foundation Server 2012 M44 (QU2). (type DatabaseSchemaException)

I'm not sure if this is a clue or not.

Last point: If I go to the TFS Admin Console, when I click on Application Tier, the screen shows a "This features has been installed but needs to be configured. Click on Configure Installed Features to begin initial configuration."

Did I miss a step?

rene
  • 41,474
  • 78
  • 114
  • 152
Patrice Calvé
  • 674
  • 6
  • 12
  • Did you install a pre-release of Update 2 (CTP for example)? – DaveShaw Sep 02 '13 at 18:53
  • If my memory serves me correct, it was a "real" Update 2, not a CTP. Presently, when I check the version, it shows 11.0.60610.1 (Tfs2012.Update3). – Patrice Calvé Sep 02 '13 at 19:05
  • Weird, Sorry, I have no ideas, best bet is hope one of the MS engineers sees this, if not, I'd cross post onto the MSDN TFS forums. – DaveShaw Sep 02 '13 at 20:12
  • are you sure you're pointing at the right data tier? – Andrew Clear Sep 03 '13 at 05:34
  • Are you able to determine what step of the update the TF400686 error occurred on? (e.g. before reboot 1, when specifying the SQL Server instance in prompt, etc) --- Also make sure the "Visual Studio Team Foundation Background Job Agent" (windows service) is not disabled and is starting automatically. --- Did you use the TFS server at update 2, or did you run update 2 and jump into update 3 right away? --- Finally you might trying setting the schema directly (backup first), see: http://stackoverflow.com/q/6047036/804797 – Arkaine55 Oct 25 '13 at 18:45
  • We restored the system from backup, and re-ran the upgrade 3. All went well. I guess I'll put this in the network glitch folder. – Patrice Calvé Oct 28 '13 at 11:58

0 Answers0