replication over a firewall and using tcp/ip 
Author Message
 replication over a firewall and using tcp/ip

Is it possible to use replication over a firewall using TCP/IP,  if so how ?
For instance what port numbers would be assigned and how would they be
assigned.

I assume that we would have to Tunnel NETbui over TCP/IP,  how do I go about
this.

Any tips would be most welcome

Kind regards

Pritpal Singh Bhamber



Sun, 30 Apr 2000 03:00:00 GMT
 replication over a firewall and using tcp/ip

Quote:

>Is it possible to use replication over a firewall using TCP/IP,  if so how
?
>For instance what port numbers would be assigned and how would they be
>assigned.

>Pritpal Singh Bhamber


The default SQL Server tcp/ip port is 1433.  You need to make sure that the
TCP/IP or
Multiprotocol network libraries are installed.  You can install them with
the SQL Server install program.  For security reasons you should probably
change the port to another less well known port which I think can also be
done in the install.  You will need to set your firewall to accept packets
from whatever IP and port you set up for SQL Server.  If a client is going
to connect through the firewall then you need to run the "SQL Client
Configuation Utility"  and set the DB-library to TCP/IP or MultiProtocol.


Sun, 07 May 2000 03:00:00 GMT
 replication over a firewall and using tcp/ip

... but there is another problem if you don't allow traffic from behind a
firewall into the corporate network.  You can't tell the SQL Server to allow
subscriptions from this server if it can't communicate with it due to one
way communication going outbound.

Is the only answer to this is an ODBC push subscription?

Dave Peterson

Quote:


>>Is it possible to use replication over a firewall using TCP/IP,  if so how
>?
>>For instance what port numbers would be assigned and how would they be
>>assigned.

>>Pritpal Singh Bhamber

>The default SQL Server tcp/ip port is 1433.  You need to make sure that the
>TCP/IP or
>Multiprotocol network libraries are installed.  You can install them with
>the SQL Server install program.  For security reasons you should probably
>change the port to another less well known port which I think can also be
>done in the install.  You will need to set your firewall to accept packets
>from whatever IP and port you set up for SQL Server.  If a client is going
>to connect through the firewall then you need to run the "SQL Client
>Configuation Utility"  and set the DB-library to TCP/IP or MultiProtocol.



Tue, 09 May 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Replication in 6.5/7.0 using TCP/IP

2. Internet replication using TCP/IP and FTP

3. TCP/IP Connections through Firewall

4. NET8 TCP/IP Firewall

5. TCP/IP Port 1498 and Firewall

6. SYBASE SQL Anywhere Client Server with TCP/IP and Firewall

7. Filemaker TCP/IP over Linux Firewall?

8. Understanding DB2 TCP/IP usage to setup Firewall Definitions

9. DB2 TCP/IP Port Usage for Setting Up Firewall Definitions

10. general tcp/IP network error after changing sql server tcp/ip address

11. Comparing NetBios->TCP/IP vs TCP/IP Sockets running SQL Server ODBC

12. Configuration Informix server with reaseau TCP/IP /Configuration serveur Informix avec reaseau TCP/IP


 
Powered by phpBB® Forum Software