OK, my problem is solved; it was a double hop issue between the various devices. Chaning the SQL service account to use Kerberos fixed it.

Another problem; is it possible to use AS in OPENQUERY statements, such as

SELECT initials AS StaffInitials

As when trying I get OPENQUERY error messages.

Thanks