sql server replication: How to change the Credential for the replication -- sql server replication

How to change the Credential for the replication

Sharad
10/30/2005 6:40:03 AM

sql server replication: Dear Friends

we are having mearge replication between two domains. Now our policy for the
SA is changed and we do not use the SA account anymore for the replication.
As we have changed the password for the SA now the replication is failed
with the follwoing error.

The process could not connect to Subscriber 'SERVER'.
(Source: SERVER (Agent); Error number: 20084)
---------------------------------------------------------------------------------------------------------------
Login failed for user 'sa'.
(Source: SERVER (Data source); Error number: 18456)
---------------------------------------------------------------------------------------------------------------

Please suggest how i can change the credential so that the new username will
be used to connect the other server for the replication.

YOur earlier reply would be a great help to me.

Best regards

Re: How to change the Credential for the replication

Tom Michaels (MSFT)
11/3/2005 10:15:27 AM

It would be nice to know if this is from SQL 2000 or SQL 2005. It would
also be good to know if you are running the merge agent via a SQL Agent job,
an API call, or via the command line. Most likely you are using a SQL 2000
SQL Agent job to sync a pull merge subscriber. In this case, you need to
examine the properties of the SQL Agent job that is failing to execute the
merge agent. In the step called "Run Agent", check out the "command", this
contains the parameters used to run the merge agent in the job. You should
be able to find -SubscriberSecurityMode 0 -SubscriberLogin
sa -SubscriberPassword XXXXXX. This is where you can change the subscriber
credential information.

Hope this helps,
Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]