SQL Server Developer Center > SQL Server Forums > SQL Server Replication > SQL server could not connect to the Distributor using the speified password
Ask a questionAsk a question
 

AnswerSQL server could not connect to the Distributor using the speified password

  • Wednesday, November 04, 2009 10:22 AMberli Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I have set up a remote distributor. I set added the replication servers to the distributor and set the remote access password
    when I attempt to define distribution on the replication servers I get the above message.
    the password is correct
    I am using sql2008 sp1 and windows 2008 r2 on all three machines

    the problem does not seen to exist on non windows 2008r2 computers, so I suspect a new security problem with r2
    anyone know how to solve this?
    thanx
    david

Answers

  • Wednesday, November 04, 2009 12:28 PMBikash Dash Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi Berli,
    Use the below approach... to solve your problem.

    1- Connect to the server where your distribution db resides
    2- Right click on the replication folder and select distributor
    properties.
    3- Select publishers. If you have already entered your publisher
    uncheck and select OK
    4- Add a new publisher
    5- Enter a password for the administrative link
    6- Connect to your publishing server and and create a new publication
    using the remote distributor.
    7- Enter the password you used earlier when assigning the publisher in
    the distrubution properties

    If you don't put in the password when you first add the publisher it
    won't accept this password later so removing and readding with the new
    password seems to work.

    Plaese Vote & "Mark As Answer" if this post is helpful to you.

    Cheers
    Bikash Dash
    MCDBA/MCITP
    • Marked As Answer byberli Thursday, November 05, 2009 12:15 PM
    •  

All Replies

  • Wednesday, November 04, 2009 12:28 PMBikash Dash Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi Berli,
    Use the below approach... to solve your problem.

    1- Connect to the server where your distribution db resides
    2- Right click on the replication folder and select distributor
    properties.
    3- Select publishers. If you have already entered your publisher
    uncheck and select OK
    4- Add a new publisher
    5- Enter a password for the administrative link
    6- Connect to your publishing server and and create a new publication
    using the remote distributor.
    7- Enter the password you used earlier when assigning the publisher in
    the distrubution properties

    If you don't put in the password when you first add the publisher it
    won't accept this password later so removing and readding with the new
    password seems to work.

    Plaese Vote & "Mark As Answer" if this post is helpful to you.

    Cheers
    Bikash Dash
    MCDBA/MCITP
    • Marked As Answer byberli Thursday, November 05, 2009 12:15 PM
    •  
  • Thursday, November 05, 2009 12:17 PMberli Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I had tried changing the password, but it had no effect. removing the replication servers from the distributor and then re-adding them solved the problem.
    It is bypassed though I have no idea why it occured in the first place.

    thanx
    david