Customer experience | Sales, Customer Insights,...

You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

(0) Share

Report

Posted on by Org Import

We restored Production database on to our lower environment and trying t o import the Org on to the restored database. We are getting this error message although we are selecting teh user who is a system admin.

What are we doing wrong?

Any help is highly appreciated...

Thanks a lot!!!

All responses (3)

Answers (0)

Suggested answer

muhammad.arshad 45 on at

Like (0)

Report

You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

This problem comes when you are trying to import an organization from a Dynamics 365 CRM database from one environment to another where you don't have System Administrator user part of new environment.

Please map the System Administrator USER with new DOMAIN ID, it will fix the issue.
Org Import 5 on at

Like (0)

Report

RE: You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

Hello Mohamed Sanuj Basheer,

Thank you for spending time and explaining this to me. I appreciate it.

But unfortunately , I have already verified all the above suggestions by you.

The user I am trying map is a System Admin and I verified that using those queries mentioned already . It just does not let me go anywhere from here and I am dead in the waters.

Thanks

Nag
Suggested answer

Mohamed Sanuj Basheer 540 on at

Like (0)

Report

RE: You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

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

Community site session details

You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

Vahid Ghafarpour – Community Spotlight

Tip: Become a User Group leader!

Leaderboard

Featured topics

Product updates

Community site session details

You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM User who has the System Administrator security role before the organization can be imported.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

Vahid Ghafarpour – Community Spotlight

Tip: Become a User Group leader!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates