By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,225 Members | 2,187 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,225 IT Pros & Developers. It's quick & easy.

access internal SQL server from 3rd party web server

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.