Re: replication over internet
- From: Scott Hunley <ScottHunley@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 30 Nov 2005 11:06:04 -0800
Paul, I am getting the following error when I attempt to download the
snapshot files from the Replication FTP Site:
Date 11/30/2005 1:20:22 PM
Log Job History
(28053-DB-inventory_master-inventory_master_a-S-HUNLEY-inventory_master-5007D5E3-0C82-47A1-A26A-5E8F52E68F83)
Step ID 1
Server S-HUNLEY
Job
Name 28053-DB-inventory_master-inventory_master_a-S-HUNLEY-inventory_master-5007D5E3-0C82-47A1-A26A-5E8F52E68F83
Step Name Run agent.
Duration 00:20:24
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
-XSERVER S-HUNLEY
-XCMDLINE 0
-XCancelEventHandle 00000828
2005-11-30 18:40:37.661 Startup Delay: 4093 (msecs)
2005-11-30 18:40:41.757 Connecting to Subscriber 'S-HUNLEY'
2005-11-30 18:40:42.008 Connecting to Distributor '28053-DB'
2005-11-30 18:40:42.729 Initializing
2005-11-30 18:40:42.919 Parameter values obtained from agent profile:
-bcpbatchsize 100000
-commitbatchsize 100
-commitbatchthreshold 1000
-historyverboselevel 1
-keepalivemessageinterval 300
-logintimeout 15
-maxbcpthreads 1
-maxdeliveredtransactions 0
-pollinginterval 10000
-querytimeout 300
-skiperrors
-transactionsperhistory 100
2005-11-30 18:40:44.121 Snapshot files will be downloaded via ftp
2005-11-30 18:40:44.301 Connecting to ftp site '28053-DB'
2005-11-30 18:40:46.334 Agent message code 20033. The process could not
retrieve file
'28053-DB_inventory_master_inventory_master_articles\20051130120007\Purchase_Order_Line_Items_1.sch' from the FTP site '28053-DB'.
The Publisher is a SQL Server 2000 Database (SP3A) running on Windows 2000
Advanced Server and the Subscriber is a SQL Server 2005 database running on
Windows XP Pro SP2. These databases on in diferent domains. I can ping the
machines from one another and I can see the FTP folder from the subscriber as
well as on the publisher.
Any ideas?
--
Scott E. Hunley (MCAD)
Measure Twice, Cut Once...
"Paul Ibison" wrote:
> Tajik,
> connectivity is really a choice between VPN or non-trusted connectivity. The
> way I see these breaking down are....
> using a VPN is secure and you'll be able to use fileshares ie there's no
> need to enable FTP. So, although you're operating over the internet things
> are much the same as per usual.
> The proxy server is an element of the connectivity to a network by acting as
> a firewall and blocking traffic on non-essential ports, and possibly
> allowing traffic from only assigned IP addresses.
> TCP/IP & FTP is the method used if you are replicating across non-trusted
> domains - ie in the absence of a VPN. You can have it operate securely by
> using a certificate and encrypting the TCP/IP traffic.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
.
- Follow-Ups:
- Re: replication over internet
- From: Paul Ibison
- Re: replication over internet
- Prev by Date: Snapshot Replication with Identity
- Next by Date: Re: problem with updating identity in transactional replication
- Previous by thread: Snapshot Replication with Identity
- Next by thread: Re: replication over internet
- Index(es):
Relevant Pages
|
