How to change DB Password ?? - Forum - OpenEdge BPM - Progress Community

How to change DB Password ??

 Forum

How to change DB Password ??

  • Hi,

    We have to change DB Password.

    Could you please suggest how to do this activity ?

    Thanks

  • Hello Pankaj,

    From SBM side, to update the database password, you must change the password in the following files:

    $SBM\conf\sbmdb.properties

    $SBM\adapters\db\conf\db.properties

    However, you will also need to update the files application server side. Let me know the app server used at your end so that I can assist you further.

    Kind Regards,

    Aasawari

  • Hi Aasawari,

    appreciate your prompt reply .

    We are using pramati server.

    Could you please name the files which need to be changed.

    Thanks,

    Regards,

    Prakash

  • Hello Pankaj,

    The following are the files and their locations that needs to be updated to change the Database Password for Pramati application server:

       

        * -resource-config.xml


        1.$SBM_HOME\pramati\server\ejbserver\config
        2.$SBM_HOME\pramati\server\nodes\portalserver\config
        3.$SBM_HOME\pramati\server\nodes\ejbnode1\config      // if cluster setup
        4.$SBM_HOME\pramati\server\nodes\jmsnode1\config    // if cluster setup
        5. $SBM_HOME\cluster\conf\sbm-cluster.xml                // if cluster setup. 

    Please note once all these files (SBM side as well as application server side) are modified, run the "updateSBM.cmd" command from $SBM_HOME\bin location.

    Let me know if this information helps you.

    NOTE : Please verify the above on Test setup first before implementing on Praduction setup.

    Kind Regards,

    Aasawari

  • Hi Aasawari,

    Its working fne...

    Thank you so much 

    Regards,

    Prakash

  • Run the DB Config tool