I upgraded one of our first vCenters yesterday to 6, and boy was it a doozy. The vCenter was at 5.5u2D, but it has been upgraded over the years (probably starting from 3.x) so it has carried over some old crud. This post will cover all of the KBs that I had to use (be ready for a link-o-rama)
vCenter 5.5u2D on a VM with it’s SQL database on a shared sql VM
The first issue that we ran into was that the database needed extra permissions (found during upgrade check phase).
Due to some internal policies, we have to move the DB to a dedicated SQL VM prior to making this change.
The next issue was that there were some old tables and constraints that the upgrader didn’t know what to do with (found during upgrade check phase).
The solution was to run a few SQL queries to drop the constraints and old tables. After running the SQL query from the KB, there were still a few tables and constraints leftover. I modified the SQL query to drop those as well.
The upgrade checker was successful at this point, but it did state that it would need to regenerate certificates (either you do and continue or you don’t and stop).
It did let me install the WHOLE thing (including generating for new SSL certs) but at the VERY end it errored with:
VMware KB: Upgrading or installing VMware vCenter Server 6.0 fails with the vminst.log error: Error in accessing registry entry for DSN