How to reset the Orchestrator 20.4 password for a local account via the SQL query?

How to reset the Orchestrator 20.4 password for a local account via the SQL query?

Follow the steps below to reset the password for admin user of default tenant.

 
1. Update the Identity.AspNetUsers table using the query below. 

UPDATE [databasename].[identity].[AspNetUsers]
Set PasswordHash=‘ALWTidnzgaDN04zwfIjlx3ogbXNNer7/QbO9y3Q4LV/MLY+2TaazMLEggpO8/b7/Kg==’, IsFirstLogin='1’
where UserName=‘admin’ AND Id=(select [Key] from [databasename].dbo.Users where TenantId=1 and username=‘admin’)

2. Update the dbo.users table using the query below. 

UPDATE [%UIPATH ORCHESTRATOR DATABASE NAME%].dbo.users
Set password=‘ALWTidnzgaDN04zwfIjlx3ogbXNNer7/QbO9y3Q4LV/MLY+2TaazMLEggpO8/b7/Kg==’, IsFirstLogin='1’
where UserName=‘admin’ AND TenantId='1’

Note :- The dbo.user has relevance when it comes to Orchestrator access token generation ~/account/authenticate. If its not changed token will not be generated based on the new password.