web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Error while importing Microsoft Dynamics CRM organization

(0) ShareShare
ReportReport
Posted on by

Hi,

I have restored the database and am trying to import the organization using this database on another server in the same active directory.

I am getting the following error.

Is there any solution for this?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Please try the following steps -

    MS Dynamics CRM 2011 Server Migration from Glenstone Production to Panth DEV Server:

    Last day was a very hard day for myself and Md. Abdullah Al Mamun We both are assigned to migrate Glenstone Production CRM 2011 Server to our Dev environment

    The most challenge tasks was:

    1. Setup Dynamics Server with Active directory

    2. Migration Glenstone CRM to panth Server CRM

    3. Users (Active Directory) Migration to panth server AD

    After we successfully installed CRM 2001 with AD, we both started to analysis how we can migrate glenstone AD users to our local CRM 2011 AD server.

    We found ADMT(Active Directory Migration Tool)

    technet.microsoft.com/.../cc974332(v=ws.10).aspx

    but ADMT has few limitations:

    1. Depend on MS SQL Server 2005 or more

    2. Both AD needs to in trusted domain

    We were not goes with the ADMT because we don't have permission over glenstone AD server.

    So how do we succeed?

    1. Back of Glenstone CRM database

    2. We restored this database to our local CRM DB with as different database than default CRM database.

    3. Start importing Organization of Glenstone CRM existing organization to our local CRM Server using "CRM Deployment Manager"

    But at one stage when deployment manager thrown error "You must map your Active Directory user account to at least one enabled Microsoft Dynamics CRM user who has the System Administrator role before the organization can be imported"

    So I goes to the Glenstone CRM database and found out that the default CRM administrator does have the permission as CRM administrator in CRM. it was also disabled.

    you will find the information on based the following table:

    1. systemUserBase (for SystemUserID and other information i.e. domain name,)

    2. SystemUserRoles for the user role.

    after setting the administrator role to admin user. it was successfully imported.

    So, we succeed.

    Checklist.:

    1. CRM user role at least one has system administrator role.

    2. SQL database version;lenstone DB case MS SQL Server R2 with SP2

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

    3. All the Roll Up 1-12

    www.microsoft.com/.../details.aspx

    4. Active Directory

    5. Organization Unit of AD

    This step by step was found here: kb.jaxara.com/ms-dynamics-crm-2011-server-migration-fr

  • Community Member Profile Picture
    on at

    Thanks Bryn.

  • Community Member Profile Picture
    on at

    No problem, if my answer helped, please could you verify

    Thank You :)

  • Verified answer
    Community Member Profile Picture
    on at

    The database backup which I was trying to restore was missing the records in "SystemUserBase" table, because of which I was getting the blank screen.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans