Post reply

subscriber is not able to get the data

  • April 6, 2009 at 12:16 am

    #208154

    Dear All

    I have 2 seperate sqlservers.one has sql 2000[subscriber] and other has sql2005[publisher] and pull subscription is using.both servers are on LAN.

    Snapshot replication is taking place. entry in hosts file hs been done.

    Yet subscriber is not able to get the data.

    Error:

    The process could not connect to Distributor 'AJAYG'. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed.

    Thanx

    Thanks

  • April 6, 2009 at 9:30 am

    #972644

    Does the account you are using on the Subscriber have access to the repldata folder?

  • April 8, 2009 at 12:57 am

    #974038

    My repldata folder is in a share folder and permission is set to everyone.

    suscriber is not able to connect to distributor ...

    Thanks

  • April 8, 2009 at 6:13 am

    #974197

    This is often a login problem. Presumably you have logged on to your Subscriber and have been able to open a Query Analyser session to your distributor using the login and password used by the distribution agent?

    Another reason could be the account under which you are running SQL Server.

    Is there no further information in the distribution agent history?

    Mike

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

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