While importing an organization into CRM, one may come across the following error message “At least the setup user needs to be mapped before this organization can be imported”.
For this issue follow these steps:
- Update “Accessmode” , “Setupuser” and “IsDisabled values in systemuser table.
Query to update:
Update SystemUser Set Accessmode=’0’, Setupuser=’0’, IsDisabled=’0
- Click Start, All Programs, Microsoft Dynamics CRM, and then click Deployment Manager.
- Click on “Import organization”
For this issue follow these steps:
- Update “Accessmode” , “Setupuser” and “IsDisabled values in systemuser table.
Query to update:
Update SystemUser Set Accessmode=’0’, Setupuser=’0’, IsDisabled=’0
- Click Start, All Programs, Microsoft Dynamics CRM, and then click Deployment Manager.
- Click on “Import organization”
- Type the SQL server name to which you want to restore the SQL Server database in the SQL Server , select the organization database and then click Next.
- Type the display name and then click Next.
- Type the report server URL, and then click Next.
- Select Manually map users, and then click Next.
- You will be able to see all the users in selected database so you need to map existing CRM users.
- Click Next after the system requirements checks are completed.
- Click Import to start the Import Organization Wizard.
- Lastly click Finish.
