Dear Partner,
Check current logged in user was disabled in the crm database.
“System Administrator” rights might be missing
Get the userid of the administration-user of the environment:
SELECT TOP (1000) [SystemUserId]
FROM [ORG].[dbo].[SystemUserBase]
where DomainName = 'domain\username’;
SELECT TOP (1000) [SystemUserId]
FROM [ORG].[dbo].[SystemUserBase]
where DomainName = 'domain\username’;
With the id of the user, enabled the user
update SystemUser
set IsDisabled = 0
where SystemUserId ='GUID'
update SystemUser
set IsDisabled = 0
where SystemUserId ='GUID'
The next step was to add the “system administrator”-Role to the user, find the id of the role:
select RoleId from Role r
left join BusinessUnit b on r.BusinessUnitId = b.BusinessUnitId
where r.name ='System Administrator' and b.ParentBusinessUnitId is null
select RoleId from Role r
left join BusinessUnit b on r.BusinessUnitId = b.BusinessUnitId
where r.name ='System Administrator' and b.ParentBusinessUnitId is null
And at the end, I added the role to the user
INSERT INTO [dbo].[SystemUserRoles]
([SystemUserId], [RoleId])
VALUES
('GUID', 'GUID')
INSERT INTO [dbo].[SystemUserRoles]
([SystemUserId], [RoleId])
VALUES
('GUID', 'GUID')
Regards,
Mohamed Sanuj Basheer
