How to connect

[adasoft]

Hi,

I am having a machine having SQL Server installed with two IP Addresses.One is local and other is global(external).My network has a router which routes the connection recieved on global IP to the local IP. If I connect from a VB application installed on a machine of my network to the SQL Server by giving local IP Address, then it works fine. But when I connect it by giving global IP Address then it fails.Can anyone help me, how can I solve this problem?

Its urgent.
Thanx in advance

 

[NoCoolHandle]

Ada..

Do you have a fire wall on your server?
What Server Librarys are you using and what do your connecxtions string arguments look like (change servernames and or ip addresses if you want)?

TO chekc Server Librarys
SQLServer Program group -> Server Network Utility
And -> in the TCP/IP (if it shows up) what is your port set at 1433 or something unique?

If it is something else, what is the client set at?

Can you Ping your Outside IP?


Rob