One of the advantages of communities is rapid discovery of exploits and their correction.
Storing passwords in plain text has been a bad idea since forever....
The fact that SSO does this practically means that ESXi Management Network, vCenter and SSO would need to be on an "air gap" network to be truly secure. After all, if I could exploit the SSO server filesystem; I could acquire the keys to the kingdom!
Please go through Installation of vCenter Single Sign On high availability or recovery node fails if Master Password and Administrator password are different in the vCenter server 51 release note https://www.vmware.com/support/vsphere5/doc/vsphere-esx-vcenter-server-51-release-notes.html
I'm not sure if you were able to try the DB Hash fix that grasshopper mentioned but it appears to have worked for me. I was able to get on and install the web client server that we never got around to installing. So far, so good.
Thanks to all who posted!
To all a big thanks, especially to grasshopper...
If in any case anyone is still wondering how to reset the admin@SystemDomain password for SSO, i found this:
It worked for me, wish you the best!
Thanks for sharing. Keep in mind that to use that reset util requires that you already know the admin@system-domain password. If you know it, then you can reset it easily. That process is well documented in the official VMware KB. Most folks here simply don't know the original password so cannot reset it like that.
As such, the only real fix thus far has been performing the DB hash technique.
The original article discussing this is in german and is located at:
The Google Translate version (German to English) of the original article:
Unrelated Note: Please be advised that my original concern from earlier in the thread about the admin@system-domain password being in plain text was incorrect. I think the only plain text password stored is that of the RSA_User which does not help in recovery unless all passwords were set exactly the same at install time. The location of that plain text password (which was originally "intentionally deleted" by me) is "C:\Program Files\VMware\Infrastructure\SSOServer\webapps\lookupservice\WEB-INF\classes\config.properties". Again, this likely won't help anyone who has forgotten the admin@system-domain password, and the fix is still to perform the DB hash technique noted from the shubis blog in germany.
hey so I think i know my admin master password because when it asks me for it it gets me to the point to ask me for the administrators name, is this suppose to be admin@System-Domain or admin@system-down or just admin?
When i type in just admin or admin@System-Domain it asks me to enter new administrators password and verify. i do that but then i get the ERROR: Failed to decrypt field com.rsa.db.user
what the heck?
also i dont remember setting too many different passwords while installing the SSO. if it lets me get past to the point of asking me the admin account with the passwrod im typing in, why cant i continue the web client install with that same password?
thanks in advance
admin@system-domain is the one you will need for the web client install. Are you able to login with that? In general, once you can login with admin@system-domain then you can create/manage those other IDs. First step though will be getting the web client installed. Also ensure you right click and run as administrator when doing the install of course.
no i cannot. i get invalid credentials in that log file.
so from this post i read the only way to reset the pw for the admin@system-domain is to use the rsautil reset-admin-password command.
but you need to know the master password, which i must know because the only password i remember configuring during the SSO install is the one im typing in when prompted for master password.
but then i get that error of faield to decrypt field com.rsa.db.user
no i cannot. i get invalid credentials in that log file.
Understood. Then you're in the right place (i.e. don't know the admin@system-domain password). That is the subject of this thread and the fixes are noted above (i.e. db hash technique). I can't tell you why the other ID throws that interesting error but you should probably get the admin@system-domain going first so you can make progress on your web client install.
trying the db hash technique now.
the pssword that im looking for is the only password that this SSO install asks you for right? the admin@system-domain ?
so i dont know where this "master password" comes from
That's correct. If SSO is already installed successfully then the only password you need is admin@system-domain, which will become a new "known" password upon completion of the db hash technique. To answer the other question, in addition to allowing you to set a password for admin@system-domain, SSO also prompts you at install time (this is already done in your case) to enter passwords for the database users as well (i.e. RSA_USER and RSA_DBA) but those you do not need to know for your immediate objective. To complete the webclient install in your case you just need the password for admin@system-domain.
what un/pw do i use to connect the sql mgmt studio to the dummy and prod dbs?
the local admin worked, but that article doenst tell you , you have to use .\VIM_SQLEXP as the sql server name, thats the name of the express instance
Yeah it needs you to know the previous password, thing is, i always knew it yet installation was blocking me from proceeding (in my case with Web Client for vSphere) as admin@SystemDomain, somehow using that precedure helped me reset it and the system was able to recognize it again.
We could say the SSO sometimes confuses its own password.
I hope it helps somebody later on that looks for a solution in a case like this.