Blue Prism Product

 View Only
last person joined: 13 hours ago 

This community covers the core Blue Prism product.

Expand all | Collapse all

BP Database Admin password lost

Jump to Best Answer
  • 1.  BP Database Admin password lost

    Posted 01-28-2020 16: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-29-2020 02: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
    Best Answer

    Posted 01-29-2020 20: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 11: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 20: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
    ------------------------------



  • 6.  RE: BP Database Admin password lost

    Posted 08-28-2021 03:00
    Thank you! This solved my issue.

    ------------------------------
    Martin Cabrera
    Montevideo, Uruguay
    ------------------------------



  • 7.  RE: BP Database Admin password lost

    Posted 04-21-2021 09:22
    Taking reference from Zdeněk Kabátek I was able to reset the password on the local installation.

    1. Install and launch SQL Server Management Studio
    2. Enter server name as (LocalDB)/BluePrismLocalDB - This could be found on BluePrism Login Screen - Configure Connection - Database Server
    3. Select Windows authentication
    4. Once logged in, on the left you will find Databases -> BluePrism
    5. In case you don't find a userid with name "admin" but only one userid in BPAPassword table, reset the password for that user. Use the below query to find user
    SELECT * FROM [BluePrism].[dbo].[BPAPassword]
    6. Create a new query and enter the below SQL update and execute

    UPDATE [BluePrism].[dbo].[BPAPassword] SET salt = 'ezfkI0NkJiIJR8Rubuuf800cxjp7epM7EjYkQIfzUxI=',hash = '96u76IApmLmLzatzGnvFzPq2h4noZZCpc+GATM2VUxk=' WHERE userid = 'admin'
    7. This will reset the admin password to a

    I used BluePrism 6.10 and it worked for me.

    Thanks Zdeněk Kabátek for the help

    Regards,
    Parnab



    ------------------------------
    Parnab Sinha Choudhury
    ------------------------------



  • 8.  RE: BP Database Admin password lost

    Posted 06-25-2021 16:26
    Hello,

    I couldn't able to see [BPAPassword] table in blueprism DB? any help?

    ------------------------------
    Divyarani B
    ASE
    IBM India Pvt Ltd
    Asia/Kolkata
    ------------------------------



  • 9.  RE: BP Database Admin password lost

    Posted 06-25-2021 16:39
    Hi,

    I tried the above mentioned steps in local installation of Blueprism 6.10. If you are using an organization version then its better to check with team who supports the platform/application. But in case you are using a local installation and not able to see the BPAPassword, in that case pls check if the DB name is "BluePrism" also you can run the below query to see all tables in the DB, usually the BluePrism related tables are prefixed with BPA. You can search in the list of tables (that will be the first column in the output of below query)

    Query to check all tables - SELECT * FROM sys.tables

    Hope that helps....

    Thanks,
    Parnab

    ------------------------------
    Parnab Sinha Choudhury
    RPA Developer / Business Analyst
    ------------------------------



  • 10.  RE: BP Database Admin password lost

    Posted 06-26-2021 10:25
    Thank you for your response. 

    when i checked my SQL server i see only one server is available i.e. \SQLEXPRESS under this i have Blueprism DB.

    earlier i used BP licensed version and now i have downloaded learning edition and i m able to see localDB connect with (LocalDB)/BluePrismLocalDB. But i could not able to connect this server.
    Please advise


    DB Instance.


    ------------------------------
    Divyarani B
    ASE
    IBM India Pvt Ltd
    Asia/Kolkata
    ------------------------------



  • 11.  RE: BP Database Admin password lost

    Posted 06-28-2021 06:01
    Hi,

    I checked this step on a newer installation of BP Learning edition and was able to connect without any issue with same parameters. I am doing it on a personal laptop. In case you are using an organization provided workstation, it will be a good idea to check with support team as organization put some restrictions. Else, there are quite a few articles in google if you search by "a network related or instance specific error" where they provide step by step guide on fixing this issue. Hope that helps.

    Thanks,
    Parnab

    ------------------------------
    Parnab Sinha Choudhury
    RPA Developer / Business Analyst
    ------------------------------



  • 12.  RE: BP Database Admin password lost

    Posted 09-01-2021 14:06
    You can use this --> 
    1) Search the name of DB connection from BP .

    Use the below command to reset BP admin password

    UPDATE BPPassword SET salt='bWHYui7HKokLnns5LlF-kTY0=99HyyYuiGtF',hash='8ZXkuDKokLnMoKezhb3l7Ch1CEDmfS8hRUdsNv8='
    WHERE userDd=(SELECT userDd FROM BPUser WHERE username='Admin') ;


    ------------------------------
    ------------------------------
    Vipul Tiwari
    Senior Process Simplification and Optimization Designer(Solutions Architect)
    Fidelity International
    ------------------------------
    ------------------------------



  • 13.  RE: BP Database Admin password lost

    Posted 01-12-2022 17:53

    Hi Vipul, 

    Thanks for the answer, can you please help us by briefing the steps to execute the command?

    Thanks & Regards, 
    Aravind



    ------------------------------
    Aravind Babu
    ------------------------------



  • 14.  RE: BP Database Admin password lost

    Posted 01-12-2022 18:07
    Hi Aravind,

    To execute this command, first you need to access SQL Server Management Studio (SSMS) which is an application available to interact with your databases on your SQL Server.

    You can download this application from Microsoft's web site and then you need to login with your SQL Server name, username and password which you can select either to be Windows Authentication if this is what you provided while installing SQL Server otherwise you need to select SQL Authentication and provide your SQL server credentials.

    Then, you need to click on 'New Script' which appears at the top and it will open a new editor screen for you where you can type and execute your query.

    Here you type the SQL Query as Vipul mentioned and then try to click on Execute button. You should be able to see a message saying some records got updated successfully in the output section below the editor screen.

    Please let us know if you have any queries.

    ------------------------------
    ----------------------------------
    Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

    Regards,
    Devneet Mohanty
    Intelligent Process Automation Consultant
    Blue Prism 7x Certified Professional
    Website: https://devneet.github.io/
    Email: devneetmohanty07@gmail.com

    ----------------------------------
    ------------------------------



  • 15.  RE: BP Database Admin password lost

    Posted 02-23-2022 12:11
    Hi Parnab

    Thanks for above response, however I don't have anything being displayed if I try to get the BPAPassword , even though it shows up on table on the left , should we recreate admin account.

    I am using 6.9 Blueprism Version




    ------------------------------
    Manpreet Kaur
    ------------------------------



  • 16.  RE: BP Database Admin password lost

    Posted 02-24-2022 07:20
    Hi, Manpreet,

    this is strange. Please check the table BPAUser if you have any user there. If yes, then you need to create a record with id of that user entered in column userid. I am sending a screen shot of my record in BPAPassword. My user name is admin with userid as displayed below.
    BPAPassword recordRegards



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



Welcome to the Blue Prism Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.