February 11, 2003 at 8:20 am
Both SQL Server are behind their own firewall and would like to access databases each other.
How do I configure firewall and ports to allow them access each other through firewall?
Any risks to SQL Server virus after opening those ports in firewall and solution to prevent the virus attack?
Thanks for your help.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply