Post reply

Errors setting up replication

  • March 15, 2005 at 1:50 pm

    #87816

    Here's the setup:

    Server 1 is publisher

    Server 2 is distributor

    Server 3 is subscriber.

    Trying to run Snapshot agent job on distributor and receive errors.  Edited the Run Agent job step to output to a file for troubleshooting.  Here is the output:

    Microsoft SQL Server Snapshot Agent 8.00.760

    Copyright (c) 2000 Microsoft Corporation

    Microsoft SQL Server Replication Agent: Server1\Instance1-GordonTEST-GordonTest-549

    Connecting to Distributor 'Server2\Instance2'

    SourceTypeId = 7

    SourceName = Server2\Instance2

    ErrorCode = 21268

    ErrorText = [SQL-DMO]Row or column specified is outside the range of the specified query result set.

    The process could not connect to Distributor 'Server2\Instance2'.

    Please help before I get any balder!!

    Gordon Pollokoff

    "Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones

  • March 18, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • March 21, 2005 at 10:09 am

    #548047

    one thing you should check.  In your snapshot agent history, there should be an entry after the snapshot agent fails.  This will give you a filename for the specific script that failed.  It's a lot easier to troubleshoot when you know exactly what died.  Good luck.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply