469,950 Members | 1,934 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

access internal SQL server from 3rd party web server

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

Sep 12 '07 #1
1 1228
Mel
Setup a VPN connection to your internal network which can access the sql
server.

"Hang" <hy***@zcap.netwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
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

Sep 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Stefan Mueller | last post: by
2 posts views Thread by Maria | last post: by
9 posts views Thread by CMan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.