The Data Migration Manager encountered an error while setting up the temporary migration database

Posted by Mike Snyder on December 19, 2007  |  Comments (2)

I have been testing the Microsoft CRM Data Migration Manager recently and it's uh...how do I say this...been a little bumpy. Of course we're pretty much flying blind with no documentation so that's added a degree of difficulty to the task. We setup a test Data Migration Manager install on a virtual client machine and spent some time trying to get it to connect to CRM. Unfortunately I kept getting stuck at this error message.

"The Data Migration Manager encountered an error while setting up the temporary migration database. Restart the Data Migration Manager, and then try migrating the data again."

Considering I am a domain administrator, a local administrator on the client machine and a system administrator in CRM...this error message caused some head scratching. However after reading through the just released Data Migration Manager read me file, I saw that this exact error was listed as a "Feature Area Known Issue". The resolution:

One possible source of this error message may be the UserReplicationID registry key. You can resolve this issue by deleting the registry key, restarting Data Migration Manager, and signing in again. You can find this registry key in the following path (depending on your system type):

• 32-bit systems: HKLM\SOFTWARE\Microsoft\Data Migration Wizard

• 64-bit systems: HKLM\Software\Wow6432Node\Microsoft\Data Migration Wizard

I followed the instructions and deleted this registry key...and now the Data Migration Manager loads like a champ!