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



.

Relevant Pages

  • Re: Replacing ISAPI web authentication filter with .NET solution?
    ... and give the user access to our website. ... SQL Server ... With the current setup, user id, password and the network user id are ... our web server. ...
    (microsoft.public.dotnet.general)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote development advice
    ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ... I want to be able to access the pages that my friend has done remotely ... Then whichever web site he has configured as the default site on IIS should appear, assuming the web server was configured correctly. ...
    (microsoft.public.dotnet.general)
  • Assistance
    ... one sql server and web server are on the same ... location with the functionality of their current website. ... will I be compromising security ...
    (microsoft.public.sqlserver.security)
  • How to connect to our internal SQL Server from outside webserver
    ... We publish our pages in a 3rd party web server, so they host our website. ... traffic needs go through our router before reach the SQL server, ...
    (microsoft.public.sqlserver.connect)
Loading