Wednesday, March 28, 2012

How to change the Credential for the 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
Sharad
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.
"Sharad" <Sharad@.discussions.microsoft.com> wrote in message
news:01EA29E2-D2DA-4748-BE15-218EDEF5625D@.microsoft.com...
> 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
> Sharad

No comments:

Post a Comment