That error is often when it cannot connect to the database, such as being blocked by a firewall.
While there are some benefits to database targets for migration manager, it's really not viable for most companies anymore. Because the migration manager packages are created in lower environments (IE DEV), you need to enable connectivity from non-production application systems to production database networks which are typically isolated for security purposes. Non-production systems often have more users with elevated access, and you don't want them to mistakenly make changes to a production system.