Configuring SQL Replication using Remote Distributor: Create Publication Error

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  March 13, 2020 at 10:47 pm

  #3734336

  If it's a default instance I believe it will use the default port. If you have a default instance and using a different port, you often need to create alias to that instance and specify the port. Not sure if that's what you did to work around it or not but that's what I've done before.

  Sue

   

• seyiisq

  Old Hand

  Points: 380

  More actions

  March 16, 2020 at 7:40 am

  #3734610

  Thanks Sue,

  It is a default instance however but the port is not a default port.

  Yes, i used the alias to resolve the connection from the publisher to the distributor and it has been working since then,

  Thanks a lot guys.

  Appreciated.

   

• mellibo

  Valued Member

  Points: 59

  More actions

  February 12, 2025 at 4:24 pm

  #4536126

  I has the some error and the solution was disabling distributed transactions at server level:

  

  Also in the link server propertires

• mellibo

  Valued Member

  Points: 59

  More actions

  February 12, 2025 at 4:31 pm

  #4536149

  I had the same problem and the solution was to disable distributed transactions at the server level.