The steps below detail how to properly remove an MDX Database Instance from a project source in Strategy Developer 9.x - 10.x:

NOTE: if the Remove button is grayed out, there are still dependents that need to be removed.
Remove the Database Instance, which is located in Administration > Configuration Manager > Database Instances
This issue has been logged as KB42467