topic RE: BP Database Admin password lost in Product Forum

BP Database Admin password lost

GeneKerls — Tue, 28 Jan 2020 16:32:00 GMT

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
------------------------------

RE: BP Database Admin password lost

vivek.kumar.goel — Wed, 29 Jan 2020 02:17:00 GMT

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.
------------------------------

RE: BP Database Admin password lost

PetriKaukua — Wed, 29 Jan 2020 11:43:00 GMT

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
------------------------------

RE: BP Database Admin password lost

zdenek.kabatek — Wed, 29 Jan 2020 20:00:00 GMT

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
------------------------------

RE: BP Database Admin password lost

zdenek.kabatek — Wed, 29 Jan 2020 20:04:00 GMT

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
------------------------------

RE: BP Database Admin password lost

ParnabSinha_Cho — Wed, 21 Apr 2021 08:22:00 GMT

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
------------------------------

RE: BP Database Admin password lost

divyarani411 — Fri, 25 Jun 2021 15:26:00 GMT

Hello,

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

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

RE: BP Database Admin password lost

ParnabSinha_Cho — Fri, 25 Jun 2021 15:39:00 GMT

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
------------------------------

RE: BP Database Admin password lost

divyarani411 — Sat, 26 Jun 2021 09:25:00 GMT

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
------------------------------

RE: BP Database Admin password lost

ParnabSinha_Cho — Mon, 28 Jun 2021 05:01:00 GMT

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
------------------------------

RE: BP Database Admin password lost

MartinCabrera — Sat, 28 Aug 2021 02:00:00 GMT

Thank you! This solved my issue.

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

RE: BP Database Admin password lost

EVIPUTI — Wed, 01 Sep 2021 13:06:00 GMT

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
------------------------------
------------------------------

RE: BP Database Admin password lost

AravindBabu — Wed, 12 Jan 2022 17:53:00 GMT

Hi Vipul,

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

Thanks & Regards,
Aravind

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

RE: BP Database Admin password lost

devneetmohanty07 — Wed, 12 Jan 2022 18:07:00 GMT

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

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

RE: BP Database Admin password lost

ManpreetKaur4 — Wed, 23 Feb 2022 12:11:00 GMT

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
------------------------------

RE: BP Database Admin password lost

zdenek.kabatek — Thu, 24 Feb 2022 07:20:00 GMT

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.

Regards

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