how can I reset vcenter single sign on administrator password

I have a vCenter server which is malfunctional. We can log onto the vcenter server, but can't use vshpere client to connect to the vcenter.

I have the database sa password and can connect to the backend SQL database, is there a way i can reset from there.
Jason YuAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
So, let me get this straight, you have forgotten the SSO password ?

You state -
We can log onto the vcenter server ?
using which account ?

If you have Forgotten the administrator@vsphere.local password, there is no method to recover it.

You will need to re-install vCenter Server.

The SSO password is hashed and encrypted and stored in the SQL database, the only method I know of, is to complete a new temp installation of vCenter Server, enter a SSO password, remember it, and then cut and paste that HASH from the Temp SQL vCenter DB, into the current database!

You could also try this method...

http://elgwhoppo.com/2013/10/22/how-to-reset-administratorvsphere-local-password-in-vcenter-5-5/
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Have you tried logging into vCenter Server using the Administrator@vpshere.local, user account and password ?
0
 
Jason YuAuthor Commented:
Yes, we can log into center now.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Jason YuAuthor Commented:
How could I reset admin's password for sso there?
0
 
Jason YuAuthor Commented:
Thank you for your help, you are the BEST :)
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Thanks for your kinds words.
0
All Courses

From novice to tech pro — start learning today.