Jessayman
asked on
VMWare - SSO Conundrum with Vcenter
So the entire issue is as follows:
Classic situation where information was not documented accurate and the Master SSO admin@system-online password was lost.
I discovered this when I went to upgrade Vcenter to 5.1 Update 1 where you are first prompted to run SSO and it states this will upgrade SSO and it asks for the master password
Located the discussion where a solution was discovered and it had me run the following query on the database
However after resetting the Vcenter SSO service
I then run the SSO install and then accept the 'upgrade' prompt after which it prompts for the password
I enter VMware1234! and it states password is incorrect or blank
At this point I am prepping a spare server I had around and do a fresh installation and then import the IMS_PRINCIPAL table and then that I would believe HAVE to resolve my issue. Was just wondering if I was missing some small step as I tend to overlook the easier things at times
Classic situation where information was not documented accurate and the Master SSO admin@system-online password was lost.
I discovered this when I went to upgrade Vcenter to 5.1 Update 1 where you are first prompted to run SSO and it states this will upgrade SSO and it asks for the master password
Located the discussion where a solution was discovered and it had me run the following query on the database
UPDATE
[Dbo]. [IMS_PRINCIPAL]
SET
[PASSWORD] = '{SSHA256}B6HO7UNHVi5fglh1RpJXX4z1maGJ9lcicTVcy94ztsmzAekseg=='
WHERE
LOGINUID = 'admin'
AND
PRINCIPAL_IS_DESCRIPTION = 'admin' UPDATE
To my understanding this would reset the master password to VMware1234!However after resetting the Vcenter SSO service
I then run the SSO install and then accept the 'upgrade' prompt after which it prompts for the password
I enter VMware1234! and it states password is incorrect or blank
At this point I am prepping a spare server I had around and do a fresh installation and then import the IMS_PRINCIPAL table and then that I would believe HAVE to resolve my issue. Was just wondering if I was missing some small step as I tend to overlook the easier things at times
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.