Problem with accessing SQL Server database throu web which is behind a firewall.

Hello all,
Well My office has 2 branches one in india and 1 in usa.
I am trying to connect the database in usa from india ..My usa server has a Static IP . but unfortunately it is Behind a firewall...Hence i am not able to connect..
Please provide me the suggestions...
saiOpen port #1433.

hth|||Originally posted by ac_nobrega
Open port #1433.

hth

Thanks Nobrega...
Can u please give me the exact syntax of the path
is it like <<server-ip>>:1433 ?

Please reply back as soon as possible..

sai|||Originally posted by vjeedigunta
Thanks Nobrega...
Can u please give me the exact syntax of the path
is it like <<server-ip>>:1433 ?

Please reply back as soon as possible..

sai

You're right.
Just put a rule in your FW that permit any traffic from/to your SQL server on port 1433.

hth.|||And may sure you're using sockets, not named pipes.
Originally posted by ac_nobrega
You're right.
Just put a rule in your FW that permit any traffic from/to your SQL server on port 1433.

hth.