Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Ok. Here is my set up: I have a a windows server 2008 with Microsoft Dynamics CRM 4.0 installed.

On a separate windows server machine is the database with SQL Server 2008 installed. We managed to get this working fine.

However, I can't get the MSCRM Migration manager to work. I have tried to run the utility on the CRM server, the SQL server and on my local machine. In all cases it will fail when verifying the SQL server with "Failed to determine the SQL data root path for CRM instance." In the verification screen it says it's checking "Microsoft SQL Server 2005," which of course, we don't have. We have 2008.

Does this mean the migration manager does not work with 2008? This seems kind of silly to me. Does anybody know if this is possible?

share|improve this question
up vote 1 down vote accepted

FYI, I got this response from an expert on CRM.

Install the SQL Express on the workstation and run DDM on the Workstation. It doesn’t need to get to the SQL 2008 server.

That worked. I thought I would leave this question in case anyone else has the same issue.

share|improve this answer

same problems! Do you use the Express SQL 2005 on the Workstation (client maschine)?. Or the SQL 2008 Express Version?

share|improve this answer
I actually don't know. The CRM install will install Express for you. I should be the correct version automatically. – Jeff Davis Jul 21 '09 at 21:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.