While working on a vSphere upgrade project for a very large install base , I faced the issue with the vCenter upgrade failing from vCenter 4.x to vCenter5 with a wrong JDBC URL failed message. This type of issue is already described in KB articles from VMware.
But my issue was different everything mentioned the KB articles was done right in this case , what I was facing was wrong URL format for the JDBC reported by the vCenter Installer , you can see the error below. There is also a reference of JDBC URL Formats for the vCenter Server Database as how it should be entered.
See the error below.
The challenge that I faced was to figure out what is the correct database used for the vCenter , to find out what is the correct database name used by the vCenter so that you can complete the correct JDBC URL in the error screen I followed the steps below.
Login to the machine where you have the vCenter database installed , open the SQL Server Configuration Manager , note down the Process ID in front of the DB instance name , under the SQL Server services option. For example here it is 1524.
Now open the Windows task manager go to services and match the process ID with the one in the task manager , this will be your database instance name used by the vCenter. In the example below it is SQLEXP_VIM.
You need to use this as the Database instance name in the vCenter Installer screen as per the JDBC URL Formats for the vCenter Server Database . Once done click next and you should proceed with the installation.