We have setup transactional replication with queued updating between two
machines. both machines have the same sqlagent account with the same
password. When inserting records on the Publishers ( e. on the table) then
the data gets replicated fine and the subscriber gets updated with the insert
record. the problem is when we try to insert the records from the subscriber
then replication fails with login. What could possible be the problem here
because the account we are using is the same and has writes in both machines
the publisher and subscriber.
Mandla,
please take a look at this link :
http://support.microsoft.com/default...;en-us;Q320773
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