topic RE: Reset Password - Learning environment in University Forum

Reset Password - Learning environment

SamLima — Tue, 17 May 2022 06:24:00 GMT

I tried many videos on YouTube to reset my password but nothing works

Could anyone help please?

------------------------------
Sam Lima
------------------------------

RE: Reset Password - Learning environment

devneetmohanty07 — Tue, 17 May 2022 06:38:00 GMT

Hi @SamLima,

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;

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

RE: Reset Password - Learning environment

Rhian.Lowe — Thu, 13 Oct 2022 10:10:00 GMT

Hi Sam

Did you ever manage to get your password reset?
I'm stuck too. I can't run the SQL script as the learning BP isn't connected to an SQL server!

Thanks

Rhian

------------------------------
Rhian Lowe
------------------------------

RE: Reset Password - Learning environment

devneetmohanty07 — Thu, 13 Oct 2022 17:48:00 GMT

Hi @Rhian.Lowe,

Blue Prism can't run without a SQL server database firstly as you can also see from the following installation guide: Install and configure trial and learning editions

To access the tables within database and execute SQL scripts, you need a software called SQL Server Management Studio

Once you are able to install the software, login to the server which is configured by default while installation as shown below:

Blue Prism Configured Database:

Same table you should be able to view inside your SSMS software once connected to server:

In order to execute script, you need to click on the 'New Query' icon or press 'CTRL+N' which opens up a new scripting window:

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

Once, you have written the script click on the 'Execute' button or press 'F5':

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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