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?