Blue Prism Product

last person joined: 10 hours ago 

Chat about Blue Prism products
Expand all | Collapse all

BP Database Admin password lost

  • 1.  BP Database Admin password lost

    Posted 01-28-2020 11:32
    I am a new-bee!!  It has been a couple of weeks since I last was able to using the training in BP.  I have BP loaded on my system, but I used the admin account to access the system to produce the results shown in the training.  Now I do not remember the admin password.  Is there anyway to retrieve the password or do I need to delete the DB and create a new one???

    Gene

    ------------------------------
    Gene Kerls
    ------------------------------


  • 2.  RE: BP Database Admin password lost

    Posted 01-28-2020 21:17
    For resetting the password of admin user ,
    1- you need admin access to the database.
    2- You need the original encrypted hash key of the password which only Blue prism may have.

    If it were a production instance, I would have suggested you to get in touch with Blue Prism support to get the password reset script. But since it's only a training instance, I would recommend you to recreate the database . This will not only help you to re-do some of the exercises to gain more hands-on but also remind you not to forget the password again :).

    Best of luck mate.

    ------------------------------
    Vivek Goel
    RPA Architect
    Asia/Singapore
    "If you like this post, please press the "Recommend" Button.
    ------------------------------



  • 3.  RE: BP Database Admin password lost

    Posted 01-29-2020 15:00
    Gene,

    if you have something in the old database which is valuable then you need to follow those steps:
    1. assumption - you have access to the database and you can modify tables - if this is not true then you are lost ;).
    2. create new database instance - this is to get salt and hash for known password (which BP version you use?)
    3. go to SQL Management console and in the newly created database with known password go to the table BPAPassword.
    4. Copy the content of column salt and hash
    5. go to the old database, table BPAPassword and write the content into salt and hash
    6. login into your old database with the password which you created for new database.

    ------------------------------
    Zdeněk Kabátek
    Head of Professional Services
    NEOOPS
    http://www.neoops.com/
    Europe/Prague
    ------------------------------



  • 4.  RE: BP Database Admin password lost

    Posted 01-29-2020 06:43
    Hi,

    If you have direct access to the database (with smss or with t-sql), it is possible to inject new password to the database from a different database.

    ------------------------------
    Petri Kaukua
    Certified Blue Prism Architect
    Digital Workforce
    Europe/Helsinki
    ------------------------------



  • 5.  RE: BP Database Admin password lost

    Posted 01-29-2020 15:04
    If you put in salt this 
    ezfkI0NkJiIJR8Rubuuf800cxjp7epM7EjYkQIfzUxI=

    and hash this 
    96u76IApmLmLzatzGnvFzPq2h4noZZCpc+GATM2VUxk=

    for admin user then the password will be "a"

    ------------------------------
    Zdeněk Kabátek
    Head of Professional Services
    NEOOPS
    http://www.neoops.com/
    Europe/Prague
    ------------------------------