Orchestrator Log In Issue: User Login Failed. (#216)

News Knowledge Base
,
1

AD user can not access On-Prem Orchestrator. Gets the error message #216.

Issue Description:

Based on the event viewer logs it is seen that User is not active. It is displayed in Orchestrator interface and have needed privileges assigned:

Resolution:

  1. Check Db tables for the specific user:

select * from dbo.users

select * from identity.AspNetUsers

  1. Check the 'IsActive' Column for the specific user in both tables. It should be set to 1 (active).
  2. Update the DB table and set IsActive=1

update [identity].[AspNetUsers] set IsActive=1 where Id = 'UserID'

Note: Id from identity.AspNetUsers should match Key column from dbo.users table.