When you try to create a new migration profile in MOSS 2007 which connects to MCMS 2002, you may get a sql connection issue.

This is due to the fact that SQL Server 2000 was not set to Mixed Mode. If it uses windows authentication mode only, the migration assistant in MOSS 2007 will not be able to connect to the data source.

To change to Mixed mode, right click on the server name in SQL Enterprise Manager –> Properties and change to Mixed mode.