Reason To Not Update The Host Tenant Password From UI Using Forgot Password Option

When is it not possible to login as Host tenant and unable to reset the password for Host tenant, how to resolve?

It is not possible to reset password from User Interface using ‘Forgot password’ option because, an invalid mail could present in the UiPath database for the admin username under the host tenant.

  1. Run the Host query in Orchestrator Database :

SELECT UserName ,t.Name ,Email

FROM [UIPATH].[identity].[AspNetUsers] anu

join [UIPATH].[identity].[Partitions] p on p.Id = anu.MasterPartitionId

join [UIPATH].[identity].[Tenants] t on t.PartitionId = p.Id

where UserName = 'admin'

and t.Name = 'host'

Required Output : The below output is obtained where their is no mail is defined.

![](upload://2NgOdgsz7D25TR4qAf75ciatyjl.html)

Hence, it is not possible to reset password from UI using ‘Forgot password’ option. There is no requirement to perform any other setting to use the UI option for forget Password.

  1. Try the same query for the Default Tenant and notice the below

SELECT UserName ,t.Name ,Email

FROM [UIPATH].[identity].[AspNetUsers] anu

join [UIPATH].[identity].[Partitions] p on p.Id = anu.MasterPartitionId

join [UIPATH].[identity].[Tenants] t on t.PartitionId = p.Id

where t.Name = 'Default'

Required output: The respective Mail id is obtained and try to reset the same to get the required output.

![](upload://1yakOdyo4kuJeSAiOWog8kEbmiP.html)

The Reset Password mail( as below) shall be received now.

![](upload://ntBL5TLYjsHmrjlsj8i4O3EteiA.html)

Resolution: If the Host Admin (3edcVFR$) requires resetting, execute the following query, replacing %UIPATH ORCHESTRATOR DATABASE NAME% with the name of the user's database.

Update [%UIPATH ORCHESTRATOR DATABASE NAME%].dbo.users

Set Password = 'AK3FINpqU/VzL+c+VL8mbk9wH35Y22bnTnGlLcAq8KKNqj2pN+3bv0+V0qoSKLIANg==', IsFirstLogin='1'

WHERE Username='admin' and Name='System' and Surname='Administrator'

From 2020.4.1


Use below SQL to reset the password of admin user under host tenant to 3edcVFR$

UPDATE [%UIPATH ORCHESTRATOR DATABASE NAME%].[identity].[AspNetUsers]

Set PasswordHash='AK3FINpqU/VzL+c+VL8mbk9wH35Y22bnTnGlLcAq8KKNqj2pN+3bv0+V0qoSKLIANg==',

IsFirstLogin = 1

where

Id = (SELECT anu.Id

FROM [%UIPATH ORCHESTRATOR DATABASE NAME%].[identity].[AspNetUsers] anu

join [%UIPATH ORCHESTRATOR DATABASE NAME%].[identity].[Partitions] p on p.Id = anu.MasterPartitionId

join [%UIPATH ORCHESTRATOR DATABASE NAME%].[identity].[Tenants] t on t.PartitionId = p.Id

where UserName = 'admin'

and t.Name = 'host'

)