CRM 4 Import Organisation fails

Today I had an issue where I could not import an organisation into CRM4, I could not get past the map user screen. I found a good forum post but it still didn't resolve the issue my issue.

The import wizard needs the setup user mapped, the setup user is the user that originally created the organisation, if the user has been disabled, or CRM system administrator rights removed then there can be problems during the import process, the below script put's things right. In fact it can even change the setup user if required.

This script will just list all the users and their security roles,



Use this script to set a user as the setup user, just update the set statement with the domain user name and run against the database you want to import.

SET @NewSetupUserDomainName = 'CRM\Administrator'