Connection problems with a dsn

[lsgtechuser]

I thought I had narrowed this down to being a firewall problem, but i think it goes beyond that.
Trying to give someone from outside the intranet access to a sql server, but when i test the dsn connection it doesn't work. When I change the connection to point to the servers internal ip instead of it's external ip the connection works.
I have the firewall setup to allow all TCP, and UDP traffic going to the server (i know this is bad i did it just for testing briefly)
For some reason I can't connect.
I have had the exact same problem with both named pipes and tcp.
Any suggestions? Thanks in advance.

 

[SQLBill]

That is a question for your system admins. Your server may not be set up with a 'non-internal' IP address.

-SQLBill

Posting advice: FAQ481-4875

 

[lsgtechuser]

Sadly, I am the systems admin there is an external ip address and i can prove that because this server ahs an ftp site and i can also remote desktop into it (externally).