SQL Server Performance Forum – Threads Archive
2005–>2005 transactional repHi
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.
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
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.
the 2005 wannabe subscriber was also a distributor for some other publications, so i just configured peer-to-peer replication, now it is working.
Did you get any errors earlier. Please note that peer-to-peer replication is working only for Enterprise Edition —————————————-