I had the same error and used a combination of the previous suggestions to resolve this.

On the source machine (my local machine in this case) I had to allow DTC...