Posted - 10/15/2012 : 06:21:05
| Hi all,
I have successfully configured the Replication between two SQL Sever 2005.
At the time of New Subscription configuration i selected following options to update data through Pull Subscription:-
Distribution Agent Location = At Subscription (pull subscription).
Distribution Agent Process Account = run under the sql server agent service account.
Connect to the Distributor = Sql Server Login like sa.
???Connect to the Subscriber = By Impersonating the process account (selected by default).
Synchronizing Schedule = run continuously, Initialize Subscriptions = immediately.
But data not updating through ?Pull Subscriptions. If i use Push Subscriptions then data updating successfully.
Please tell me where i am doing wrong and suggest some solution to update data through pull.
i will be very thankfull to you.