July 14, 2004 at 8:58 pm
Hi, I have created a subscription on a remote server but cannot get it to acknowledge the snapshot folder on my local server. The snapshot folder is set up as a declared share folder and has been added to 'My Network Places' on the remote computer. On the remote computer Windows 2000 can see the folder but the SQLAgent/SQLServer processes appear not to be able to.
When the subscriber runs I get the following error:
Could not find the cabinet file 'snapshot.cab' in folder
'\\XXX\ReplData\unc\XXX_TESTDB_PBData\20040715111435\'. The step failed.
When I check the folder the snapshot file is there.
Also when trying to setup the snapshot file location for the subscription using SQL Server Enterprise Manager I get the error:
\\XXX\ReplData' is not a valid path, or it refers to a file instead of a folder. Enter the path to an existing folder.
Any ideas ?
Thanks.
July 16, 2004 at 7:17 am
Replication runs under the SQLSERVERAGENT service and the Enterprise manager Replication facility runs under the MSSQLSERVER service on the publisher and subscriber servers. In Enterprise Manager right click on the server names and select properties. Go to the Security tab on check what Windows Account the services are running under. These accounts need to be given 'Full Control' security permission in Windows to the replication shared folder.
The account these services are running under can also be checked/changed in Windows Control Panel - Administration Tools - Services. Right click on the service, go to properties then choose the Log On tab.
All the best
Peter
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply