How to reset the Admin password for the ConfigDB

Version 1

    Details

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


    This article applies to the ConfigDB only. 

    To reset the password for HeatSM please see KB 12712.
    To reset the password for the Ops Console please see KB 24935.

     


    Resolution

     

    The table that lists the ConfigDB user information is the Profile table. 
    The following SQL code will set the Ops Console Admin password to: manage

    USE ConfigDB
    UPDATE Profile
    SET InternalAuthPasswd = 'kBzocZXiPfB3THJnlq5BxSIuoSr7awCcSn4C+iIhgo9hWOfW'
    WHERE LoginID = 'Admin'

    or 

    USE ConfigDB
    UPDATE Profile
    SET InternalAuthPasswd = 'kBzocZXiPfB3THJnlq5BxSIuoSr7awCcSn4C+iIhgo9hWOfW'
    WHERE LoginID = 'HSWAdmin'