How to reset the Admin password for the Operations Console

Version 1

    Details

    If you need to reset the Admin password for the Operations Console, you can do so through MS SQL.


    This article applies to the Operations Console only. 

    To reset the password for HeatSM please see KB 12712.
    To reset the password for ConfigDB please see KB 24936.

     


    Resolution

    The Operations Console information can be located in the ConfigDB.


    The table that lists the Ops Console users and passwords is the frs_ops_mia_users table. 
    The following SQL code will set the Ops Console Admin password to: manage

    USE ConfigDB
    UPDATE frs_ops_mia_users 
    SET Password = '3F282FCBA8933E03A65A6DC92A27DE8396961E2F'
    WHERE Login = 'Admin' 

    or

    USE ConfigDB
    UPDATE frs_ops_mia_users 
    SET Password = '3F282FCBA8933E03A65A6DC92A27DE8396961E2F'
    WHERE Login = 'HSWAdmin'