Error 20033, Pull merge replication using FTP 
Author Message
 Error 20033, Pull merge replication using FTP

Hi,

I'm trying to set up a merge pull subscription via FTP using MS
SQLServer 7. I've got the snapshot folder set to a folder on the FTP
server and the snapshot is generated and placed there okay. The
following error (#20033) occurs when I try to create and initialize a
pull subscription:

The process could not retrieve file
'publisherservername_dbname_publication\2000090516025\tablename.sch'
from the FTP site 'FTPServerName'.

I can connect to the FTP site using the command prompt. We're using NT
Security for the SQLServer. Is this a permissions problem?? We've tried
changing various permissions to no avail.

Any ideas or suggestions please reply,

Thanks,
Peter

Sent via Deja.com http://www.***.com/
Before you buy.



Sun, 23 Feb 2003 23:10:17 GMT
 Error 20033, Pull merge replication using FTP

I was having the same problem... when I created the subscription, I refered
to the local server as (local)... I got the same error, its very strange...
every thing seems legit.. You HAVE to drop the subscription referring to
(local) again, then recreate it explicitly using sql server name on the sub
side...

weird thing is you can add an identical sub w/out dropping the one referring
to (local)... then it never seems to work right again! until you remove the
hidden one from (local)

--Scott Kramer


Quote:
> Hi,

> I'm trying to set up a merge pull subscription via FTP using MS
> SQLServer 7. I've got the snapshot folder set to a folder on the FTP
> server and the snapshot is generated and placed there okay. The
> following error (#20033) occurs when I try to create and initialize a
> pull subscription:

> The process could not retrieve file
> 'publisherservername_dbname_publication\2000090516025\tablename.sch'
> from the FTP site 'FTPServerName'.

> I can connect to the FTP site using the command prompt. We're using NT
> Security for the SQLServer. Is this a permissions problem?? We've tried
> changing various permissions to no avail.

> Any ideas or suggestions please reply,

> Thanks,
> Peter

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Mon, 24 Feb 2003 02:29:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Cant initialize pull subscriptions using ftp in Merge Replication

2. Error using FTP in Merge Publication with Pull Subscription

3. Problem with FTP when I use Pull Merge replication accross VPN

4. Problem with FTP when I use Pull Merge replication

5. Synchronise using FTP for Snapshot Location Fails - Merge Replication

6. merge replication using ftp

7. Merge Replication with ftp fails after adding A New Merge Article

8. Merge Replication, on-demand PULL replication

9. snapshot ftp delivery error in merge replication

10. 20033-NC-RTP-SYBASE-ORACLE-WIN-NT-INFMX4G-HARDWARE-DBMS-Sr. Software Engineer

11. 20033-NC-RTP-SYBASE-ORACLE-WIN-NT-INFMX4G-HARDWARE-DBMS-Sr. Software Engineer

12. Creating a Pull Replication using TSQL, but run into errors


 
Powered by phpBB® Forum Software