Probable cause

You attempted to create a foreign key that cannot be enforced. In order to be enforceable, the primary and foreign table for the specified key must exist on the same server. You can use the UNENFORCED keyword to create a foreign key specification that is not to be enforced.