Restore the Administrator password

HI Guru's,
Can any please help me how to recover the Administrator user password in the Repository Manager.I forgot the Administrator password , which was not default password .we had changed long back .i tried to recover password from Meta Data or Repository tables but unable to do ,since the passwoird is encryted.please help ASAP .
Thanks in advance
Hari

HI Tapas, Can u plz help me .how to reset the password.
i had naviagated to ../informatica/server/
There i typed as PMCMD then it prompt PMCMD>
i am trying to connect as follow
connect -u Administrator -p encryptedpassword from the opb_user table -s servername:portno
it throughing error.
The connect request failed because the client application is trying to connect to server type [pmserver]. Repository Server accepts only requests for server types REPSERVER and REPAGENT
ERROR: Cannot connect to Informatica Server
plz help me
Thanks,
Hari

Hi Tapas,
Thank you very much for u suggestion. i had checked the Repository manager
administrator password in the repo table and update the administrator
default password with new instance password and connect to RM.it work
for eg: i have forgot the administrator password for the Devlopment
instance, and i check the production instance password from repo table
opb_users;
updates the dev repo table with prod repo table and connect from Repository
Manager.
thanks,
Hari

Well good that you can log in, but make sure that other user and passwords are ok and others can login also.
I would have given you the command line syntax, but it has been a long time since I tried that and i have kind of forgotten.
Please see the manual for command tasks and you should be able to figure out the alternative way instead of copying the entire table.

Could you please tell me how did you connected with the pmcmd command bcoz i am unable to to that and even i tried to find the opb_user table in my metadata but coudn't do that.. could please tell me how did you resolved the probelm.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.