How to login to a remote SQL Server instance via IP and specify the Server name?

Posted: - Source : stackoverflow

I'm following instructions HERE to add a remote publisher to a Distributor server here. However, when trying to add a publisher via SQL Server Authentication I get the following error:

enter image description here

THIS recommends checking to see the machine name and servername is the same:


They are.

And there is a stack overflow question ( that recommends adding an additional connection parameter SERVER='XXX'. But this also doesn't work. I get the following error screen: enter image description here

Both named pipes and TCP connections are enabled on both machines. And I'm able to login via the connection manager when not trying to configure publications.

So I think my question is, how can I specify a servername using SQL Server authentication as if I were logging into the server via a Windows login?