SQL2000 & firewall though ASP page 
Author Message
 SQL2000 & firewall though 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:39:08 GMT
 SQL2000 & firewall though ASP page

Mark,

Two things
        1)  Check out the article
                Q287932 INF: TCP Ports for Communication to SQL Server Through Firewall
                http://support.microsoft.com/support/kb/articles/q287/9/32.asp

        2)  Are you accessing the server by name or by ip address.  Can you ping
the server by which ever method you are using?

John Gose
MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS", with no warranties, and confers no rights

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------

| Subject: SQL2000 & firewall though ASP page
| Date: Mon, 3 Dec 2001 20:39:08 -0000
|
<Snip of Header Stuff>
|
| 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 12:22:17 GMT
 SQL2000 & firewall though ASP page
the connection string (standard DSN-less) has the fqdn, but on the web
server i can ping that fqdn and it returns the ip and  can ping fine. Indeed
i can even get some sort of telnet connection to it on port 1433 (goes to
blank screen with cursor top left and after a minute or so 'loses conncetion
to host').

I will speak to our firewall ppl and get there comments on that article -
thanks

I'm sure it has everything to do with the firewall but from the article I
guess alot of ports would become accessible again (defeats object of
firewall :) )

thanks for help

Mark



Quote:
> Mark,

> Two things
> 1)  Check out the article
> Q287932 INF: TCP Ports for Communication to SQL Server Through Firewall
> http://support.microsoft.com/support/kb/articles/q287/9/32.asp

> 2)  Are you accessing the server by name or by ip address.  Can you ping
> the server by which ever method you are using?

> John Gose
> MCDBA
> Microsoft SQL Server Support

> This posting is provided "AS IS", with no warranties, and confers no
rights

> Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

> --------------------

> | Subject: SQL2000 & firewall though ASP page
> | Date: Mon, 3 Dec 2001 20:39:08 -0000
> |
> <Snip of Header Stuff>
> |
> | 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 19:31:44 GMT
 SQL2000 & firewall though ASP page
Mark,

Thanks for the update.  Let me know the results of the conversation w/ your
network folks.  Remember that it is 1433 in and any out.  This is because
the reply-to port is controled by the client, aka your web server, and is a
randomly choosen port.

John Gose
MCDBA
Microsoft SQL Server Support

This posting is provided "AS IS", with no warranties, and confers no rights

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------


| Subject: Re: SQL2000 & firewall though ASP page
| Date: Tue, 4 Dec 2001 11:31:44 -0000
| Lines: 77
|
<Snip of Header Stuff>
|
| the connection string (standard DSN-less) has the fqdn, but on the web
| server i can ping that fqdn and it returns the ip and  can ping fine.
Indeed
| i can even get some sort of telnet connection to it on port 1433 (goes to
| blank screen with cursor top left and after a minute or so 'loses
conncetion
| to host').
|
| I will speak to our firewall ppl and get there comments on that article -
| thanks
|
| I'm sure it has everything to do with the firewall but from the article I
| guess alot of ports would become accessible again (defeats object of
| firewall :) )
|
| thanks for help
|
|
| Mark
|


| > Mark,
| >
| > Two things
| > 1)  Check out the article
| > Q287932 INF: TCP Ports for Communication to SQL Server Through Firewall
| > http://support.microsoft.com/support/kb/articles/q287/9/32.asp
| >
| > 2)  Are you accessing the server by name or by ip address.  Can you ping
| > the server by which ever method you are using?
| >
| > John Gose
| > MCDBA
| > Microsoft SQL Server Support
| >
| > This posting is provided "AS IS", with no warranties, and confers no
| rights
| >
| > Are you secure? For information about the Microsoft Strategic Technology
| > Protection Program and to order your FREE Security Tool Kit, please
visit
| > http://www.microsoft.com/security.
| >
| >
| > --------------------

| > | Subject: SQL2000 & firewall though ASP page
| > | Date: Mon, 3 Dec 2001 20:39:08 -0000
| > |
| > <Snip of Header Stuff>
| > |
| > | 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
| > |
| > |
| > |
| >
|
|
|



Mon, 24 May 2004 04:16:43 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. SQL2000 & Firewall thru ASP page

2. Performance: Paging recordsets via SQL2000/ASP

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

4. DTS though a firewall

5. DTS though a firewall

6. Error when connecting SQL2000&ASP

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

8. Executing DTS via ASP & web page

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

10. %FIREWALL% %FIREWALL% %FIREWALL%

11. how to run a dts from a web page like an asp.net page

12. Multiple record recordsset w/Page Breaks in ASP Pages


 
Powered by phpBB® Forum Software