Setup a new Publisher

  • Hi,

    I receive the following error message when I try to setup a new publisher on the server, after completed the new distributor setup.

    "SQL Server Enterprise Manager could not configure 'Data-server' as the Distributor for '192.168.xxx.xxx'.Error 17: SQL Server does not exist or access denied."

    As you can see from the above message, the two servers are in the different lan/domain and they can't see each other by name, so I use their ip address to register each other

    in the SQL Enterprise Manager.

    Is there a way to setup a publisher just by the server ip address insteady of the servername?

    Thank you for your help in advance!

  • What is asking is the name of the SQL Server Instance, you could try adding an alias in the SQL Server client net library.

    But check that you can use a distributor in another domain, the publisher must have access permission to the distributor, and also to the OS.

  • Hi Racosta, thanks for your advice, it's do help to solve my problem!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply