Replication using FTP within firewall 
Author Message
 Replication using FTP within firewall

Hi,
I have problem on merge replication using FTP.
Any help will be sincerely appreciated.

I have server A (SQL Server 2000) behind firewall, and
Server B (SQL Server 2000)no firewall.
How to configure the servers so that i can do the merge
replication?

I can view the server B at Server A using Enterprise
Manager by register the IP Address of server B. But I
can't view the server A at Server B using Enterprise
Manager. I received the error message "Timeout Expired".
How can I view the server A at Server B?

Thanks and regards,
Clarin Tan



Fri, 05 Nov 2004 11:03:11 GMT
 Replication using FTP within firewall

If NAT is configured on the firewall, the Server A needs to be on a fixed
external address and you also need to open TCP/1433 port on the firewall to
that server. If you plan to use FTP, may also need to open ports 20/21.


Quote:
> Hi,
> I have problem on merge replication using FTP.
> Any help will be sincerely appreciated.

> I have server A (SQL Server 2000) behind firewall, and
> Server B (SQL Server 2000)no firewall.
> How to configure the servers so that i can do the merge
> replication?

> I can view the server B at Server A using Enterprise
> Manager by register the IP Address of server B. But I
> can't view the server A at Server B using Enterprise
> Manager. I received the error message "Timeout Expired".
> How can I view the server A at Server B?

> Thanks and regards,
> Clarin Tan



Fri, 05 Nov 2004 23:56:26 GMT
 Replication using FTP within firewall

Try pinging the serverA from ServerB. If you get the
response, set the login time out to 0 in the tools-option-
advanced tab in the EM of serverB and try it.

Quote:
>-----Original Message-----
>Hi,
>I have problem on merge replication using FTP.
>Any help will be sincerely appreciated.

>I have server A (SQL Server 2000) behind firewall, and
>Server B (SQL Server 2000)no firewall.
>How to configure the servers so that i can do the merge
>replication?

>I can view the server B at Server A using Enterprise
>Manager by register the IP Address of server B. But I
>can't view the server A at Server B using Enterprise
>Manager. I received the error message "Timeout Expired".
>How can I view the server A at Server B?

>Thanks and regards,
>Clarin Tan
>.



Sat, 06 Nov 2004 03:33:49 GMT
 Replication using FTP within firewall
we had this exact same problem and looked at the firewall
as it was connecting and saw it was the name lookup it was
going for.

add the machine name and IP to the hosts file so it
bypasses the lookup and all will work fine

-chrishawn

Quote:
>-----Original Message-----
>Hi,
>I have problem on merge replication using FTP.
>Any help will be sincerely appreciated.

>I have server A (SQL Server 2000) behind firewall, and
>Server B (SQL Server 2000)no firewall.
>How to configure the servers so that i can do the merge
>replication?

>I can view the server B at Server A using Enterprise
>Manager by register the IP Address of server B. But I
>can't view the server A at Server B using Enterprise
>Manager. I received the error message "Timeout Expired".
>How can I view the server A at Server B?

>Thanks and regards,
>Clarin Tan
>.



Sat, 06 Nov 2004 04:02:24 GMT
 Replication using FTP within firewall
Dear all,
Thanks for your help. I get it already.
I define the IP Address and server name at the lmhost file
for these two servers. Then go to client Network utility
to set the server alias for the server. Then the timeout
expired do not display anymore. and my merge replication
function also work.
Thanks a lot. :)

Best regards,
Clarin Tan

Quote:
>-----Original Message-----
>Hi,
>I have problem on merge replication using FTP.
>Any help will be sincerely appreciated.

>I have server A (SQL Server 2000) behind firewall, and
>Server B (SQL Server 2000)no firewall.
>How to configure the servers so that i can do the merge
>replication?

>I can view the server B at Server A using Enterprise
>Manager by register the IP Address of server B. But I
>can't view the server A at Server B using Enterprise
>Manager. I received the error message "Timeout Expired".
>How can I view the server A at Server B?

>Thanks and regards,
>Clarin Tan
>.



Sat, 06 Nov 2004 09:02:51 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Replication through firewall using ftp

2. Replication through a firewall using ftp

3. FTP from within PL/SQL using Java stored procedure

4. replication over a firewall and using tcp/ip

5. Transactional replication over the internet using a firewall

6. replication with ftp - cryptic ftp server

7. transactional replication using ftp

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

9. Replication using FTP

10. merge replication using ftp

11. Cant initialize pull subscriptions using ftp in Merge Replication

12. Replication using FTP


 
Powered by phpBB® Forum Software