SQL2000 & Firewall thru ASP page
have you tried to connect to sql server using query analyzer from the iis
server ?? Maybe try creating an alias (specifying the ip address and the tcp
port) and then use this alias from your apps (query analyzer, connection
strings, etc).
--
HTH
---------------------------------------------------------------------
Carlos Eduardo Rojas
MCSE+I, MCDBA, MCSS, SQL Server MVP
Author: SQL Server Programming By Example
http://www.sqlserverbyexample.com
Quote:
> Hi,
> We have an ASP page that updates a table in an SQL2000 server. This worked
> fine until we installed a firewall. The firewall has been setup to allow
> traffic to the DMZ (web server side) on port 1433, but when running the
page
> we get a server host cannot be found error.
> The firewall NAT's the public IP to a private 172.16.x.x IP, and wondered
if
> it is the private IP that the SQL server is trying to respond to?
> If anyone knows what the solution to getting our page working through the
> firewall, I would be very grateful.
> thanks in advance
> Mark
