Problems with ODBC behind pix 501

Posted on 2005-04-28
Last Modified: 2010-04-08
hey guys have I'm having a problem with connecting to sql server from  behind my pix 501 firewall.

I have a few web servers and sql servers behind my firewall. in my config file i use the alais command so that my users can access the servers via domain name. I can can connect to the servers many differnet ways from the inside: ftp, http, remote desktop, and telnet. I just can't make a odbc conection. If i move the servers out side the firewall it works fine. Does anyone have any ideas?

Also the access command works good, however it's and older command and not supported by the PDM...does anyone have an updated command?
Question by:BoB7869
    LVL 79

    Expert Comment

    The updated alias is the "outside nat" with "dns" keyword, i.e.

      static (outside,inside) <private IP> <public ip> dns netmask

    Author Comment

    I tried the command, but it doesn't seem to work. I'm not running a DNS server. Does "dns" need to be something? This is line I used:

    static (outside,inside) dns netmask
    LVL 79

    Accepted Solution

    If you're not running dns for sql, then the dns keyword is irrelevant.

    i think you're going to be stuck with making the odbc connection using the private IP address and not the public IP address.
    It will be MUCH easier on you in the long run...

    Author Comment

    So I'm still having problems with this...forget the Alias stuff. Here is how it's setup:

                    |   |
                    |   |
     Computer A   Computer B

    I can't complete an odbc connection between Computer A and Computer B. They don't have any firewalls on the local machines. If I move them completely outside and try to connect via odbc it works fine without problems.  Each of them are running sql2000. I can connect to the local databases, but i can't connect to each other (I tried IP and names). Both and sure and do everything else just fine.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    From Cisco ASA version 8.3, the Network Address Translation (NAT) configuration has been completely redesigned and it may be helpful to have the syntax configuration for both at a glance. You may as well want to read official Cisco published AS…
    This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now