SQL2000 & Firewall thru ASP page 
Author Message
 SQL2000 & Firewall thru ASP page

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



Sat, 22 May 2004 04:38:11 GMT
 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



Sun, 23 May 2004 08:01:53 GMT
 SQL2000 & Firewall thru ASP page

Hi Mark,

Check out the following Microsoft Knowledge Base article.

  Q287932 INF: TCP Ports for Communication to SQL Server Through Firewall
  http://support.microsoft.com/support/kb/articles/q287/9/32.asp

Best of Luck,

Chris Skorlinski, MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.



Tue, 25 May 2004 11:27:53 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL2000 & firewall though ASP page

2. error while connecting to sql server from asp page thru odbc

3. Performance: Paging recordsets via SQL2000/ASP

4. Pb droit d'accès Cube Analysis services (SQL2000) via page ASP

5. Error when connecting SQL2000&ASP

6. Crystal reports & ASP pages (open objects setting)

7. Executing DTS via ASP & web page

8. ASP & ADO Paging against Oracle - (no) Performance

9. OLE DB Port Thru Firewall

10. Ports needed to be opened thru a firewall to access SQL Enterprise Manager

11. Can't connect to cube thru firewall

12. Connection thru a firewall


 
Powered by phpBB® Forum Software