After moving VirtualCenter database update manager displays an error

After moving VirtualCenter 5.1 database to a different SQL server the Update Manager component displays an error stating the following:

There was an error connecting to vmware vsphere update manager {vcenterserver1:443} 

Database temporarily unavailable or has network issues

Opening up ODBC thru administrative tools -> data sources does not show a System DSN for “UMDB”. It will only display the VCDB connection 

To display the “UMDB” connection run the following command in start -> run

C:\Windows\SysWOW64\odbcad32.exe

This will display the 32 bit ODBC connection and from here you will be able to repoint the Update Manager database to the proper SQL server

One Response to After moving VirtualCenter database update manager displays an error

  1. Bill D says:

    Many thanks – I’ve been searching and searching for a solution and finally came across yours – the one that worked for our situation.

Leave a Reply

Your email address will not be published. Required fields are marked *