How does "OtherServer" in SSDT database references work?
I just tried this locally and it resolves fine and also complains about the one column that doesn't exist.



Check your reference properties I have highlighted the ones used in the four part name.