SQL and Firewall

Hi,
I'm using a sonicwall firewall.My website is on a DMZ and SQL Server is on the main network server.
I need to create rules on the firewall for the DMZ to talk to SQL Server.

I have created 2 rules already - to allow DMZ talk to LAN on port 1433 and vice versa.
However it still aint working.

I'm going to create an odbc link for the website.


Does anyone have any idea of how this works or what i'm doing wrong?

Thanks
Dave

MS SQL also uses UDP port 1434, IIRC - if you are using the TCP/IP netlib. The named pipes netlib works on top of NT Netbios/SMB/CIFS, ports 135-139 and 445 - I'm not sure of other netlibs.

Try http://www.sqlsecurity.com/DesktopDefault.aspx for more info.

TRy http://www.iana.org/assignments/port-numbers for other port numbers. e.g. ODBC on port 1521.