Hello,
I have several servers SQL with replications they are a priori, configure
all similar, nevertheless on the one if I change the password of the account
"sa" replications are not done any more. Here is the message of the log "
The job failed. The Job was invoked by User sqladm. The last step to run
was step 1 (Run agent.)." Only the password of "sa" has to change "sa" is
owner job. Then why the problem comes of sqladm? With the other servers not
of problem.
Thank you.
Vincent,
are you using trusted connections or sql authentication for your agents?
Have a check in the distributor properties to verify, as it would seem your
agents are using 'sa' to log in. If this is the case, the password will need
updating here also.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment