February 11, 2003 at 8:36 am
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
INF: Replication Setup Over a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;164667
To avoid risk, set the SQL Servers to communicate with each other directly, specifying the port. If you do this, you don't have to open up UDP/1434. UPD/1434 is used to resolve the port SQL Server is listening on for a given instance. You don't want to open this up as there should not be a need to.
FYI, for ADO:
HOWTO: Use ADO to Connect to a SQL Server That Is Behind a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;269882
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply