SQL Server Performance

2005-->2005 transactional rep

Discussion in 'SQL Server 2005 Replication' started by Ncoalw, Jun 19, 2006.

  1. Ncoalw New Member

    Hi
    I have an environment where a 2005 server(distributer) is publishing an article that is subscribed to by 3 different 2000 subscribers(transactional), this same 2005 server is a subscriber to a 2000 transactional publication. this is all working successfully,
    though when i attempted to enlist a 2005 subscriber to the transactional publication published by the 2005 server it doesnt seem to work? (even though it works with the 2000 servers) the 2000 servers are all on sp4 & the 2005 servers are using sp 1.
    Please Help?
  2. satya Moderator

    It doesn't seem work means did you get any error or information during the process?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. Ncoalw New Member

    the 2005 wannabe subscriber was also a distributor for some other publications, so i just configured peer-to-peer replication, now it is working.
  4. dineshasanka Moderator

    Did you get any errors earlier. Please note that peer-to-peer replication is working only for Enterprise Edition

    ----------------------------------------
    http://dineshasanka.blogspot.com/

Share This Page