Transactional Replication error

  • Error 14080 The remote server does not exist or has not been designated as a valid Publisher.

    Help me!

  • Could you give us more information? It this an existing replication setup? Are you configuring replication for the first time on these servers? If so, what have you done so far?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Connect to your distributor using Enterprise Manager. Go to Tools, Replication, Configure Publishers, Subscibers, and Distributors. Click the publishers tab. Is there a check mark to the left of the problem publishers? Ensure there is. If there is you might want to click on the three ellipses to the right of the publisher and uncheck the Administrative Link Password check box and try again.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

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

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