I was trying to upgrade the vcenter version from 5.5 U3E to 6.5 U3. Upgrade process failed and we restored the changes from snapshots and SQL Server database restored from backup. Post restoration, Inventory is empty and unable to connect through domain ID. In SQL Database, found two schema using. One is dbo and other one is VMW. While trying SQL query, vCenter Data’s are available in VMW Schema, but vcenter can’t read the data from VMW. Can we move/alter/copy data from VMW Schema to default schema i.e. dbo? Does it will resolve the issue?
I have created a new Windows 2012 R2 server and installed fresh copy of vcenter 5.5 U3E. Also pointed to the existing external SQL database from ODBC, test connection is successful however vcenter can’t read data from Database.
Configuration are as below:
- VCenter Server – VC Version 5.5 U3E, Installed on Windows 2008 R2 server
- SQL Server version is MS SQL 2008 R2 Ent Service Pack 2.