access internal SQL server from 3rd party web server -- dotnet web services

Hang
9/12/2007 8:31:24 AM

Hi,
We publish our pages in a 3rd party web server, so they host our website.
but behind scence data is stored in our internal SQL server, all outside
traffic needs go through our router before reach the SQL server, so in the
Web Configuration file, in connection string entry, "Data Source", what
should I put in, I tried the router IP address, it won't work; I also tried
our SQL IP address, it won't work either because the IP address is internal.
at debugging time, it all works because everything is local, but when we
publish to the 3rd party web server, we CANNOT get internal data from the
website. So my altermate question is how to let the web server retrieve data
from our SQL server, or what is the format of the connection string?

Please help!

Hank

Mel
9/14/2007 4:06:54 PM

Setup a VPN connection to your internal network which can access the sql
server.

[quoted text, click to view]

dotnet web services : access internal SQL server from 3rd party web server