Monday, February 20, 2012

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
>
>

No comments:

Post a Comment