Results 1 to 3 of 3

Thread: SQL and Firewall

  1. Jan 21st, 2003, 11:49 AM #1
    DaveR
    DaveR is offline

    Thread Starter
    Hyperactive Member DaveR's Avatar
    Join Date
    Mar 2001
    Location
    Ireland
    Posts
    268

    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
    DaveR
    Reply With Quote Reply With Quote
  2. Jan 21st, 2003, 11:54 AM #2
    JoshT
    JoshT is offline
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    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.
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    Reply With Quote Reply With Quote
  3. Jan 22nd, 2003, 10:07 AM #3
    JordanChris
    JordanChris is offline
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Newbury, UK
    Posts
    1,878
    TRy http://www.iana.org/assignments/port-numbers for other port numbers. e.g. ODBC on port 1521.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width