Hi all
I changed the 'sa' password and after that I got the following errors in the subscription job history:
1-Connecting to Subscriber 'SAONT045\REPORT'
2-Login failed for user 'sa'.
3-The process could not connect to Subscriber 'SAONT045\REPORT'. The step failed.
4-The job failed. The Job was invoked by User sa. The last step to run was step 1 (Run agent.).
What can I do??
Are there anything that I can do to solve that problem without recreate the replication again?
Thanks in advance
Manuel Rodriguesthis is just a hunch but is the sa password the same on both the publisher and subscriber.|||Sounds like you need to check security settings on the Distribution agent. I usually set it to impersonate using Windows authentication, since both SQLAgent services are running under the same Windows account (easier to maintain).|||Make sure the credentials used by SQL serer agent successfully logs into subscriber
Masanam
Sunday, March 25, 2012
Replication timeout
Labels:
alli,
database,
errors,
following,
history1-connecting,
job,
microsoft,
mysql,
oracle,
password,
replication,
server,
sql,
subscriber,
subscription,
timeout
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment