• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Problems with ODBC behind pix 501

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?
0
BoB7869
Asked:
BoB7869
  • 2
  • 2
1 Solution
 
lrmooreCommented:
The updated alias is the "outside nat" with "dns" keyword, i.e.

  static (outside,inside) <private IP> <public ip> dns netmask 255.255.255.255
                                                                      ^^
0
 
BoB7869Author Commented:
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) 192.169.xxx.xxx 64.81.xxx.xxx dns netmask 255.255.255.255
0
 
lrmooreCommented:
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...
0
 
BoB7869Author Commented:
So I'm still having problems with this...forget the Alias stuff. Here is how it's setup:

              Pix501
                  |
                  |
              Switch
                |   |
                |   |
 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.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now