November 7, 2002 at 9:06 am
Howdy All!
This is a newbie question, so bear with me.
We need to access a SQL server that is behind a firewall, via ODBC, from a remote location that is outside the firewall.
What ports do I need to open on the firewall?
Is the ODBC setup procedure on the remote machine the same as usual?
TIA for the help.
November 7, 2002 at 10:57 am
November 7, 2002 at 11:39 am
Make sure you set up the ODBC connection to use the TCP/IP netlibrary.
Also, if you're going to expose a SQL Server, I'd advise changing the port SQL Server is listening on from 1433. Whatever port number you choose is the one you'll need to open as opposed to 1433. Otherwise the KB article Antares has cited should answer your questions. As far as the ODBC connection is concerned, you can specify the port when you specify the netlib, so that shouldn't be a concern.
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
November 7, 2002 at 12:17 pm
OK, got it.
Actually, it appears as though I had it to begin with, I was just forwarding to the wrong port on the inside.
Thanks to both of you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply