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:
THIS recommends checking to see the machine name and servername is the same:
SELECT SERVERPROPERTY(N'servername') SELECT @@SERVERNAME
And there is a stack overflow question (https://stackoverflow.com/questions/8212032/sql-server-replication-requires-the-actual-server-name-to-make-a-connection-to-t) that recommends adding an additional connection parameter
SERVER='XXX'. But this also doesn't work. I get the following error screen:
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?