How to unlock user admin ?

[NONTHAKORNPRISA]

I have 1 user login Blue Prism is user "admin" only.
But user "admin" is lock.
How to unlock user admin ?

------------------------------
NONTHAKORN PRISAROJ
Technical Architect
ZyGen Co., Ltd.
Asia/Bangkok
------------------------------

[james.man]

Hello Nonthakorn, are you looking to change the admin password because it has been forgotten?

------------------------------
James Man
Senior Product Consultant
Blue Prism
Asia/Hong_Kong
------------------------------

[NONTHAKORNPRISA]

Yes, and I would login Blur Prism.

------------------------------
NONTHAKORN PRISAROJ
Technical Architect
ZyGen Co., Ltd.
Asia/Bangkok
------------------------------

[JerinJose]

​Which version of BP are you using?

You can change password from Database table. it is stored in Hash and salt in Version 6 so its bit difficult. if you are using version 5 its doable.by running a DB script


------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------

[james.man]

Hello, I've contacted you privately through email on what to do when these kinds of situations occur.

------------------------------
James Man
Senior Product Consultant
Blue Prism
Asia/Hong_Kong
------------------------------

[NONTHAKORNPRISA]

I user version 6.4

------------------------------
NONTHAKORN PRISAROJ
Technical Architect
ZyGen Co., Ltd.
Asia/Bangkok
------------------------------

[NONTHAKORNPRISA]

------------------------------
NONTHAKORN PRISAROJ
Technical Architect
ZyGen Co., Ltd.
Asia/Bangkok
------------------------------

[NONTHAKORNPRISA]

I can resolve problem

I write sql script

update BPAUser
set loginattemps=0
where username='admin';

It's work !!

Thank you very much.

------------------------------
NONTHAKORN PRISAROJ
Technical Architect
ZyGen Co., Ltd.
Asia/Bangkok
------------------------------

[JerinJose]

Cool
Good that you remember the password. For changing password you have to update the salt and hash in BPAPassword Table for admin userid in Version​ 6

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------

[NONTHAKORNPRISA]

Thank you very much.

------------------------------
NONTHAKORN PRISAROJ
Technical Architect
ZyGen Co., Ltd.
Asia/Bangkok
------------------------------