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

Question

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

Answer 1

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

Answer 2

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