Copy database wizard did not work for me too.
There were several reasons with no clear solutions.

But I found one nice workaround. I backed up the database from the source server to a file. Then on the target server, I just restored the database from the file.

See if it works for you.