SQL Server Performance

Replication = Desperate confusion

Discussion in 'Performance Tuning for SQL Server Replication' started by akothand, Jan 26, 2004.

  1. akothand New Member

    Hi all,

    I have configured replication, with 3 servers. Publisher in one server, the Distribution db in a second server and the subscriber db in the third.
    The Setups went thru fine ! The Snapshot agent ran to success..
    -- message being -> "A snapshot of 5 Articles was generated"

    Now, when the Distribution agent runs, it tries for 10 or 15 times, then fails with an error :
    --------------------------------------------------------------------------------
    Error Detail : The process could not connect to Subscriber 'L1SQLFIN01'.
    Full message : General network error. Check your network documentation.
    ---------------------------------------------------------------------------------
    I have checked the following :
    1) Linked server exists between the distributor server and Subscriber server.
    2) The SQL Server agent at the distribution server is logged on as a Domain account (Having access to the suscriber server)

    I am confused what else this error could mean ?
    Thanks a tonne for your assistance !


    Thanks,
    Anand.K
    akothand@indymacbank.com

    "What would you attempt to do if you knew that you could never fail"
    -Robert Schuller
  2. Twan New Member

    Hi Robert,<br /><br />On the distribution server, log into a console session as the domain account that you run the SQLAgent with. Then start Query Analyser and connect to your subscriber database using Windows Integrate security (if that is what you want your subscription to do). Resolve any errors that you find along the way, or post error messages here <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />NOTE that this won't work through a firewall unless the Windows Authentication ports are opened up (they will vary with the type of OS/Domain you're running) If you go through a firewall and want to keep the firewall as secure as possible then you'd need to use SQL Security.<br /><br />Cheers<br />Twan

Share This Page