I had a situation this past week where a customer was attempting to upgrade their vCenter 2.5 U3 install to U4 and during the installer (just after where it asks for the DSN, Username and Password) it would error saying that it cannot connect. This is where I come in.
After looking at their VMINST.LOG on the vCenter server, I see the following;
VMware VirtualCenter-build-147658: 05/05/09 22:15:25 Error returned while checking the Virtual Center database for jobs. This could be because the installer could not connect to the database pointed to by the DSN, or due to insufficient privileges to query the database.
This does not tell me very much, but the most common problem with this error is that the user they’re attempting to connect as does not have db_owner rights on MSDB (needed only during install and upgrade). So, I ask them to give the user db_owner privilege and we try again. No luck, same exact error.
After a few hours of clicking, searching and twittering I ask them what version of SQL they are running – come to find out they have recently upgraded their SQL Server from 2005 to 2008 — BINGO!
Microsoft SQL 2008 is not supported in vCenter 2.5, however it will be supported in vCenter 4.0 – so I tell the customer they can either wait until 4.0 comes out to do the upgrade, or they will need to revert the 2008 database back to 2005….which is a lot easier said than done.
Biggest Takeaway from this experience… VM Administrators need to work closely with their DBAs, do not allow upgrades of any part of the Virtual Eco-System that may take it out of support! Also, check the Compatibility lists before doing any such upgrade.