October 1, 2004 at 4:17 am
Hi,
I have a problem in merge replication which is related to the snapshot propagation. I have created a publisher in windows 2003 machine, sql server 2000 with sp3 and subscribers in msde sp1. When I am synchronizing the subscriber with publisher I got the following error:
“The schema script '\\SUBIN\ReplData\unc\SUBIN_TestRep_TestRep\20041001131221\test_1.sch' could not be propagated to the subscriber.
The schema script '\\SUBIN\ReplData\unc\SUBIN_TestRep_TestRep\20041001131221\test_1.sch' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not read file '\\SUBIN\ReplData\unc\SUBIN_TestRep_TestRep\20041001131221\test_1.sch' due to OS error 5.
(Source: ARIHANTJAIN (Agent); Error number: 0)
---------------------------------------------------------------------------------------------------------------
Access is denied.
(Source: (OS); Error number: 5)”
The snapshot folder is shared with full access rights to all users.
Kindly help me out solving the above issue.
I will be highly grateful of you.
Thanks
Regards
Subin
May 3, 2007 at 5:12 am
The SQLServerAgent service is the "user" that performs the replication, not the user that's logged in. Make sure that the account assigned to this service has the correct permissions to access that share.
Jay Madren
May 3, 2007 at 5:12 am
The SQLServerAgent service is the "user" that performs the replication, not the user that's logged in. Make sure that the account assigned to this service has the correct permissions to access that share.
Jay Madren
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply