Results 1 to 2 of 2

Thread: Database Replication in two SQL 2008 servers.

  1. 10-23-2012, 06:06 AM #1
    hspatil31
    hspatil31 is offline Registered User
    Join Date
    Apr 2009
    Posts
    2

    Database Replication in two SQL 2008 servers.

    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 out how to resolve this issue ?


    Thanks and Regard's
    Harish Patil
    Reply With Quote Reply With Quote
  2. 10-23-2012, 08:12 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Which replication did you set? Are those machines in same domain? Did you get any error when config replication?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules