MS SQL is the backend database, yes. If you have access to the DB server,
the easiest way to view/modify the table is via MS SQL Server Management
Studio.
– Open MS SQL Server Management Studio and point it to the server/instance
that houses your vcenter SSO database.
– Expand the Databases object, then expand the vcenter SSO database (this
could go by any name, if you’re unsure you may have to check within multiple
DBs)
– Expand the tables object and look for the table with “IMS_CONFIG_VALUE”
in the name
– Right click on that table and choose edit top 200 rows
– When those are displayed you can find and edit the fields referenced,
which will change where the vmware SSO service looks to bind to AD. In my case I
altered:
ims.ldap-slots.0.primary-url
ims.ldap-slots.0-global.primary-url
ims.ldap-slots.0-global.secondary-url
Probably a good idea to note the current values and double check the new
values you enter. Changes made are effective immediately.