I want to implement Replication on my SQL server.And i have two different server like server1 and server2 with SQL Server 2005 installed including All Agent services.
Firstly i configured Distributor on both server (using SQL Server M.Studio).
Then i configured & Publish DB on Server1 with Snapshot publication type (using SQL Server M.Studio).
Then i configured Subscription DB on Server2 (using SQL Server M.Studio).
Now i want that Subscriptions DB use Pull Subscription option to update data from publication DB to subscriptions.
So at the time of Subscriptions DB configuration i select "Run each agent at its Subscriber (pull subscriptions)" to reduce workload of Server1.
But Subscriptions DB not updating any Data from publish DB.
Please tell me where i am doing wrong and please tell me if any additional configuration required.
I will be very thankful to you.