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
| > |
| > |
| > |
| >
|
|
|
