Sql-server – SQL 2008 publisher -> SQL 2000 subscriber: Is a pull subscription possible for merge replication

replicationsql serversql-server-2008

I am trying to synchronize a SQL 2000 SP4 subscriber to a SQL 2008 publisher via a merge pull subscription. When the subscriber tries to run the merge agent, it fails the following error: 

The process could not connect to Distributor 'OH05DBS002\SAM_SSG_2008'. SQL Server does not exist or access denied.

Has anyone had success with this setup? I was able to create and synchronize a push subscription so I know that communication works between the two, at least from 2008->2000. The lack of communication from 2000->2008 also affects the ability to create a linked server on the SQL 2000 subscriber. One other tidbit – I did install the SQL 2008 native client on the the 2000 box but it didn't help either.

Before anyone asks, I can't upgrade the subscriber as it still needs to support replication between MS Access 2003. Yeah, I know. 🙂

TIA,

Brian

Best Answer

Are you able to use Query Analyzer on the SQL 2000 server to connect to the SQL 2008 server? If that doesn't work nothing else will.

Start with the basics. Is the SQL Browser running on the SQL 2008 server? Can you ping the SQL 2008 server from the SQL 2000 server? Can you access the TCP port that the SQL 2008 instance is listening on?

Related Topic