How to login to a remote SQL Server instance via IP and specify the Server name?
The solution that worked was to create an alias of (server name => IP address of the publisher) on the local machine on the configuration manager.

Though I suspect that this could also have been added to the windows host file on the local server

On configuration manager, I added the following:

Name: &lt;@@SERVERNAME&gt;
Server: IP address
Protocol: TCP (not sure why this isn't named pipes)
port: 1433