Password Recovery Issue

[brana]

Hey Guys !!

I am facing issue with Blue Prism Password recovery while using the Learning Edition. As I reset the password and after some time it does not work it is really frustrating I have all my Objects and Processes and now I am stuck here. It would be great if someone could help me out with this issue.

[devneetmohanty07]

Hi @brana ,

Please use the below query to reset the password of blue prism for the username: 'admin' in SQL Server Management Studio (SSMS):​

SET salt='bWBTNqWrvq6RbQnns5PpF+Kt7V1gVS97F6R5iZIxV6M=',
hash='9XkueyLzhbhRUMoKedsN3l7ChDmfS811IDymP8ZCEv8=' WHERE
userid=(SELECT userid FROM BPAUser WHERE username='admin')
AND active=1;​

[brana]

hey @devneetmohanty07 

I tried using this method but it seems like Blue prism is not resetting even after updating database.

[devneetmohanty07]

@brana - Can you show us a screenshot of exactly what error are you getting?

[brana]

@devneetmohanty07  Im not getting any error but after updating the database it's still saying login user and password is incorrect.

[devneetmohanty07]

@brana - Can you try the below script once on SSMS. I think my prior shared query might not be working because of new Blue Prism v7 environment and I have tested the same on v6.10:

USE [Blue Prism]
UPDATE BPAPassword SET salt = '', hash = '208512264222772174181102151942010236531331277169151', type = 0
WHERE userid = (SELECT userid FROM BPAUser WHERE username = 'admin')

Once reset, try username and password as admin and let me know

[brana]

It worked this time.

@devneetmohanty07  Thanks a lot for the help Brother.