all groups > sql server replication > august 2006 >
You're in the

sql server replication

group:

Anonymous Pull Subscription without Initial Snapshot?


Anonymous Pull Subscription without Initial Snapshot? Matthew Bando
8/7/2006 11:00:29 AM
sql server replication: I'm looking for any advice/help with the following situation:

We have a SQL Server 2000 server outside of our firewall which our vendor
can access. The vendor updates data, and we wish to replicate this data
through the firewall and into our internal SQL Server 2000 server. The
firewall will only allow 1433 sessions to be initiated from inside the
firewall, so the external server cannot register the internal server as a
valid subscriber. I guess this means that I have to use an anonymous
subscriber?

Additionally, SMB and FTP are not allowed through the firewall since we do
not control the external server, so I cannot get the internal server to
initialize via snapshot. I can initialize via a backup/restore, but I can't
seem to get an anonymous pull subscription without accepting initialization
via snapshot. Any ideas?

Thanks in advance

Re: Anonymous Pull Subscription without Initial Snapshot? Hilary Cotter
8/7/2006 6:38:43 PM
Anonymous require a snapshot. Have them open the port for inbound
communication on port 1433 long enough for you to register and pull the
subscription.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

AddThis Social Bookmark Button