Search code examples
sql-servervmware

vCenter server (web client and vsphere client) can't read data from SQL server

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 otherone is VMW. While trying SQL query, vCenter Data's are available in VMW Schema, but vcenter can't read the data from VMW. Configuration are as below:

  1. VCenter Server - VC Version 5.5 U3E, Installed on Windows 2008 R2 server
  2. SQL Server version is MS SQL 2008 R2 Ent Service Pack 2.

enter image description here

Solution

  • Thanks, Issue resolved now...

    https://kb.vmware.com/s/article/2075440
    https://kb.vmware.com/s/article/1005157

    If the schema is not DBO ensure that sysadmin is not selected for the user under Server Roles.
    I have removed the User ID from Sysadmin group, and VC start reading data from SQ Database.