To resolve the issue, remove the old vCenter Server instance from the Single Sign-On database.
To remove the old vCenter Server instance from the SSO database:
- Identify the current vCenter Server instance in the vpxd.cfg file located at C:\ProgramData\VMware\VMware VirtualCenter.
- Open vpxd.cfg file using text editor. You can see the current vCenter Server instance ID and name:
<lookupService>
<serviceId>{9300C2AC-4D97-4191-8EB1-387D9823E6E3}:23</serviceId>
</lookupService>
Note: Take a backup of the RSA (Single sign on) database before editing.
- Stop the vCenter Single Sign-on service (SSO).
- Log in to the SQL Management Studio and go to the RSA (SSO) database.
- Expand Tables.
- Right-click LS_SERVICE_ENDPOINT table and click Edit Top 200 Rows.
In the last column you see the service ID, look for the two entries associated to vCenter Server.
For example:
{9300C2AC-4D97-4191-8EB1-387D9823E6E3}:23
20 https://VC.DOMAIN.com:443/sdk <Binary data> 0 19
23 https://VC.DOMAIN.com:443/sdk <Binary data> 0 23
- Right-click and delete the row with old value ( row 1 in the above example).
- Expand Tables.
- Right-click LS_SERVICE table and click Edit Top 200 Rows.
In the first column you see the service ID, look for the two entries associated to vCenter Server.
For example:
19 vCenterServer_2013.01.15_092833@System-Domain 5.1 vCenter Server vCenterService urn:vc NULL
23 vCenterServer_2014.07.09_165913@System-Domain 5.1 vCenter Server vCenterService urn:vc NULL
- Right-click and delete the row with the old ID.
- Start the vCenter Single Sign-on service (SSO) service and login in to the Web Client to test if the issue is resolved.