Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database Replication in two SQL 2008 servers.

Author  Topic 

hspatil31
Posting Yak Master

182 Posts

Posted - 2012-10-23 : 05:29:23
Dear All,

I have successfully configured the database replication on my servers.
Distribution and Publication database is on machine-1.
And Subsciber database(Replicated) is on machine-2 and also on machine-1.
Whenever transaction hapeens it replicating on machine-1 only not on machine-2.
So I have checked the Event log so I got the error as,

Error:
"Replication-Replication Distribution Subsystem: agent machine-1-SBCSS-SP-machine-2-4 failed. The process could not connect to Subscriber 'machine-2'."

I can connect the machine-2 database from the machine-1.

Can anyone please help me how to resolve this issue ?


Thanks and Regard's
Harish Patil
   

- Advertisement -