firewall rules for SQL Server

[Mike Husler]

If we are doing a 1-way replication from a SQL Server 2000 (Publisher)
through a firewall to a SQL Server 2005 (Subscriber), do any ports need
to be opened from the Subscriber back to the Publisher? That is, we
have 1433, 1434 opened outgoing from the Publisher to Subscriber but for
successful communications, do any ports have to be opened the other way?

Sorry, I'm new to this.

Thanks,
Mike H.

[Jim]

Re: firewall rules for SQL Server

On 2008-05-19, Mike Husler <Michael.P.Husl er@noaa.govwrot e:

If we are doing a 1-way replication from a SQL Server 2000 (Publisher)
through a firewall to a SQL Server 2005 (Subscriber), do any ports need
to be opened from the Subscriber back to the Publisher? That is, we
have 1433, 1434 opened outgoing from the Publisher to Subscriber but for
successful communications, do any ports have to be opened the other way?

When we do replication between sites we tend to only open port 1433. Well,
we tend to use a different port, but you get the picture.

Jim
--
http://www.ursaMinorBeta.co.uk http://twitter.com/GreyAreaUK

"Sometimes when I talk to a Windows person about using a Mac,
I feel like I'm explaining Van Halen to a horse." Merlin Mann