Networking Forums

Networking Forums > Computer Networking > Windows Networking > SQL Server ODBC Port Filtering on a DMZ

Reply
Thread Tools Display Modes

SQL Server ODBC Port Filtering on a DMZ

 
 
ReddogCA
Guest
Posts: n/a

 
      01-29-2008, 09:19 PM
I have a problem with my MS Server 2003 on the DMZ network requesting an ODBC
connection to another MS Server 2003 on my trusted network with SQL Server
2000.
The DMZ server has its ODBC configured to use port 1433 which is the
standard port for MS_SQL_Server.
I made a rule on the Firewall to allow port 1433 in order for incoming and
outgoing traffic from the DMZ to reach the SQL Server on the trusted network.
But it does not work because the DMZ Server makes the ODBC connection
request with a dynamic port number (it changes port numbers every time).
The good news is that the MS Server 2003 on my trusted network with SQL
Server 2000 listens with port 1433, as configured.
I verified this with the "netstat" command.
The ODBC connection only works when I allow "Any" ports from the DMZ to the
trusted network.
But, by doing this it will disavow the use of the firewall.
My question is...how can I force the MS Server 2003 on the DMZ to make the
request with a static port number instead of a dynamic port number?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Navision c/odbc driver on Server 2008 64 Bit FaBu Windows Networking 2 08-13-2009 12:18 PM
Filtering by Hwaddr With Port Forwarding Mark Nenadov Network Routers 0 01-03-2007 05:07 PM
Port Filtering Dustin Broadband Hardware 2 08-15-2004 03:26 PM
TCP/IP Port Filtering Russ Swartz Windows Networking 2 02-27-2004 08:59 AM
Unable to load SQL server ODBC driver F. Grignola Windows Networking 0 07-04-2003 05:51 PM



1 2 3 4 5 6 7 8 9 10 11