2

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:

SELECT SERVERPROPERTY(N'servername')
SELECT @@SERVERNAME

They are.

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: 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?

8
  • Is SQL Browser started? – Erik Darling May 18 '17 at 18:18
  • eh... what is SQL Browser? – Zach Smith May 18 '17 at 18:18
  • 2
    I'm not Googling that for you. – Erik Darling May 18 '17 at 18:19
  • :p. Yea. I'm looking now. thanks - this is the first I've heard of it – Zach Smith May 18 '17 at 18:19
  • @sp_BlitzErik. On the local machine (i.e. the SQL Server box where the Distributor Server is running), SQL Server Browser is NOT running. On the machine that I'm attempting to register as the publisher, SQL Server Browser IS running – Zach Smith May 18 '17 at 18:28
0

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: <@@SERVERNAME>
Server: IP address
Protocol: TCP (not sure why this isn't named pipes)
port: 1433 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.