Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
neellotus
Starting Member
15 Posts |
Posted - 2013-03-08 : 23:59:17
|
Hi All,I created pull subscription from Subscriber through New Subscription Wizard with each agent running at its subscriber, i m using option "Run Under Sql Server Agent Service Account" To Specify the domain or machine account under which Distribution Agent process will run when synchronizing this subscription database.And sa login of Publisher SQL Server to connect Distributor on Distribution Agent Security window.My publisher running very well and it is generating data on shared UNC folder very well.But subscriber not updating data from it. and it is showing error due to os error 5 on Replication Monitor of Publisher.This is right or i am doing some wrong and role of sa user for both sql server is already db_owner.Pls help me i will be very thankful to you.Neel |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-11 : 00:35:10
|
What's the error? Access denied?Did you walk through the wizard? How did you create the subscription? There is a sql server replication account. Saved the password? I usually use the SQL Agent account. |
|
|
|
|
|