Password change

Hi,
I have a pull merge replication configured on two of my servers. These
servers replicate over the internet and use the sa password to connect to the
publisher. I know it is not a good practice to use the sa login for
replication purposes. But it has been configured this way. It would be too
much work to re-configure it. I am not sure about this.
But the question that I want to ask is, if i change my subscribers sa
password, replication stops working.
Can someone tell me what the problem can be?
Thank you in advance.
Regards,
Karthik
try to change also the sqlagent pasword.
zrod
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:CFBAAC11-60D8-4A9F-88D2-D14B98E4ED8D@.microsoft.com...
> Hi,
> I have a pull merge replication configured on two of my servers. These
> servers replicate over the internet and use the sa password to connect to
> the
> publisher. I know it is not a good practice to use the sa login for
> replication purposes. But it has been configured this way. It would be too
> much work to re-configure it. I am not sure about this.
> But the question that I want to ask is, if i change my subscribers sa
> password, replication stops working.
> Can someone tell me what the problem can be?
> Thank you in advance.
> Regards,
> Karthik
|||Your pull subscriber authenticates with the agent locally. You can specify
the account to use as well as its password via agent properties.
I think you want to look at [Distributor/Publisher/Subscriber]SecurityMode
and the logon and password parameters.
You should be able to use the accounts of your choice here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:CFBAAC11-60D8-4A9F-88D2-D14B98E4ED8D@.microsoft.com...
> Hi,
> I have a pull merge replication configured on two of my servers. These
> servers replicate over the internet and use the sa password to connect to
the
> publisher. I know it is not a good practice to use the sa login for
> replication purposes. But it has been configured this way. It would be too
> much work to re-configure it. I am not sure about this.
> But the question that I want to ask is, if i change my subscribers sa
> password, replication stops working.
> Can someone tell me what the problem can be?
> Thank you in advance.
> Regards,
> Karthik