July 9, 2003 at 11:31 am
I am setting a snapshot replication between two SQL
servers, both are Win2000 service with service pack 3 and
SQL 2000 Enterprise Edition with service pack 2.
PUSH subscription SUCCESSFUL, but PULL subscription FAIL
as the following:
Publisher and Distributor are both in Server 1. Snapshot
Successful.
Subscriber in Server 2. It fails with:
Error Message:
The process could not read file '\\DBSQL\...\TBL.sch' due
to OS error 5.
Error Details:
Access is denied (Source: (OS); Error number: 5).
I am using the default path for replication or special
another path. And it is already sharing
with "\\DBSQL\SHARING", share to everyone with Full
Control. So, I don't know why is it still Access is denied.
But in window explorer, I can see the '\\DBSQL\SHARING',
but need to type Administrator password at the first time
with connection.
Please help.
July 9, 2003 at 12:21 pm
What are the disk permissions (not the share permissions)?
Andy
July 9, 2003 at 3:10 pm
I tried other solution and it worked properly. Basically, our suscribers are downloading the snapshot folder using FTP and also configured the snapshot folder location on the publisher. To reach it, I installed IIS on Windows 200 in each suscriber.
July 9, 2003 at 3:15 pm
quote:
What are the disk permissions (not the share permissions)?RESPONSE:
The disk permissions are:
everyone (FULL CONTROL). Our computers are in a WORKGROUP and not in a DOMAIN.
Each sql server agent start with the account .\Administrator.
July 11, 2003 at 10:44 pm
If your server is in a domain so:
1-Your SQL Server Services at subscriber server must be run with your domain user account.
2-Make new snapshot share folder on publisher
3-Select this new folder for snapshot files.
3-Remove everyone and add your domain user account to this share folder security .
hjg
hjg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply