SQL 6.5 – to – SQL 2000 replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 6.5 – to – SQL 2000 replication

Here is what we are trying to solve:<br /><br />-We have a SQL 6.5 server (version 6.50.25<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> we will call SQL65-A, on an NT 4.0 machine (version 4.00.1381), on Domain-A<br /><br />-We are trying to replicate directly to a SQL 2000 server (version 8.00.81<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> we will call SQL2000-A, on a Windows 2000 machine (version 5.00.2195), on Domain-B<br /><br />-We also have a SQL 6.5 server we will call SQL65-B in Domain-B<br /><br />-The domains are trusted<br /><br />-We get the error that it cannot connect to the SQL 2000 server when trying to replicate, even though I can register the SQL 2000 server as a Remote Server<br /><br />The work-around we have right now is replicating from SQL65-A to SQL65-B, then using SQL65-B as a subscriber as well as a distributor/publisher to SQL2000-A.<br /><br />
Can you post the exact error message? Ensure both the SQL installations are equipped with latest patches and service packs.
May check from the network side to see whether any authentication issues. (in future kindly post the thread in relevant forums only, this thread moved from analysis forum_ Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>