PORTS USED

Hey all

I am using Transactional replication with updatebale subscriptions

What network ports are used for SQL server 2005 replication

This is for firewall config.

Thanx

The agent will attempt to connect to SQL Server on the port that you have setup in the Network Config. Ususally its 1433 TCP by default.

Martin

|||

Hi all,

I have some doubts about this issue too. We are preparing a landscape to set SQL Server 2005 replication between a internal server and another one in Internet. We need to set the firewall to allow only the ports needed. The only port we need is 1433? The distributor and publisher are in the server in Internet, and the subscriber will stay in our internal network.

Regards

Sergio

PORTS USED

Hey all

I am using Transactional replication with updatebale subscriptions

What network ports are used for SQL server 2005 replication

This is for firewall config.

Thanx

The agent will attempt to connect to SQL Server on the port that you have setup in the Network Config. Ususally its 1433 TCP by default.

Martin

|||

Hi all,

I have some doubts about this issue too. We are preparing a landscape to set SQL Server 2005 replication between a internal server and another one in Internet. We need to set the firewall to allow only the ports needed. The only port we need is 1433? The distributor and publisher are in the server in Internet, and the subscriber will stay in our internal network.

Regards

Sergio

PORTS USED

Hey all

I am using Transactional replication with updatebale subscriptions

What network ports are used for SQL server 2005 replication

This is for firewall config.

Thanx

The agent will attempt to connect to SQL Server on the port that you have setup in the Network Config. Ususally its 1433 TCP by default.

Martin

|||

Hi all,

I have some doubts about this issue too. We are preparing a landscape to set SQL Server 2005 replication between a internal server and another one in Internet. We need to set the firewall to allow only the ports needed. The only port we need is 1433? The distributor and publisher are in the server in Internet, and the subscriber will stay in our internal network.

Regards

Sergio

Ports for Repication

Hi,
I want to set up a transactional replication between 2 sqlserver2000
databases.
Can anybody say me the ports I need for the replication.
Tanks
Jeanette
for ftp its 21 and 1433
for unc its 137 and 1433
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Jeanette" <needmoreinfo@.gmx.de> wrote in message
news:%23xqxOQWdEHA.3796@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I want to set up a transactional replication between 2 sqlserver2000
> databases.
> Can anybody say me the ports I need for the replication.
> Tanks
> Jeanette
>
|||However,does 1433 hold if you are not using 1433 as the
normal listening port for SQL Server? I somehow doubt it.
|||good point. I guess I should have said
for ftp its 21 and whatever port SQL Server communicates on, the default is
1433
for unc its 137 and whatever port SQL Server communicates on, the default is
1433
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Allan Hirt" <anonymous@.discussions.microsoft.com> wrote in message
news:697c01c47577$67ab63e0$a501280a@.phx.gbl...
> However,does 1433 hold if you are not using 1433 as the
> normal listening port for SQL Server? I somehow doubt it.
>
|||Thanks for your help.
but now I have another problem. What can be the mistake when my Server is
not listening on the port 1433?
Thanks
Jeanette
"Hilary Cotter" <hilaryk@.att.net> schrieb im Newsbeitrag
news:uFLNhZYdEHA.712@.TK2MSFTNGP09.phx.gbl...
> good point. I guess I should have said
> for ftp its 21 and whatever port SQL Server communicates on, the default
is
> 1433
> for unc its 137 and whatever port SQL Server communicates on, the default
is
> 1433
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Allan Hirt" <anonymous@.discussions.microsoft.com> wrote in message
> news:697c01c47577$67ab63e0$a501280a@.phx.gbl...
>
|||Open the "SQL Server network utility"
Add TCP/IP to the enabled protocols, and edit it to set the listening port.
Restart SQL Server.
"Jeanette" wrote:

> Thanks for your help.
> but now I have another problem. What can be the mistake when my Server is
> not listening on the port 1433?
> Thanks
> Jeanette
>
> "Hilary Cotter" <hilaryk@.att.net> schrieb im Newsbeitrag
> news:uFLNhZYdEHA.712@.TK2MSFTNGP09.phx.gbl...
> is
> is
>
>

Ports and Replication in SQL Server 2000

Hi,
We are trying to configure sql server 2000 transactional replication across
2 data centres through vpn and firewall. While port 1433 is open for sql
server communication, it looks like the anonymous pull subscription uses a
different port to download the initial snapshot files.
We are not using FTP to download the snapshot files, bu the option to find
the snapshot files in the default folder.
We would like to know which port that the replication agent uses to download
the snapshot files to be opened? Can this port be configured to a fixed
unused port and how? Is FTP the best way for this scenarion?
Thanks for your help and time.
Vivek
If you don't use FTP SQL will download the snapshot from the default folder
which is usually a shared folder (NETBIOS).
I don't know the ports you have to open to make that works... but you
certainly don't want to do that...
I think you should activate the FTP server in your internal network (ie:
using the VPN) and make the subscribers download the snapshots from there.
Jos.
"vivek" <vivek@.discussions.microsoft.com> wrote in message
news:9F8EF204-2EB0-489C-AF3C-4D12B4BCEC59@.microsoft.com...
> Hi,
> We are trying to configure sql server 2000 transactional replication
across
> 2 data centres through vpn and firewall. While port 1433 is open for sql
> server communication, it looks like the anonymous pull subscription uses a
> different port to download the initial snapshot files.
> We are not using FTP to download the snapshot files, bu the option to find
> the snapshot files in the default folder.
> We would like to know which port that the replication agent uses to
download
> the snapshot files to be opened? Can this port be configured to a fixed
> unused port and how? Is FTP the best way for this scenarion?
> Thanks for your help and time.
> Vivek