SQL Server Performance

SQL 6.5 - to - SQL 2000 replication

Discussion in 'Performance Tuning for SQL Server Replication' started by dba723, Apr 4, 2005.

  1. dba723 New Member

    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 />
  2. satya Moderator

    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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page