How does SQL communicate?

[jafo45]

Can anyone help ?

I'm tasked with getting a SQL server to pass its data through an ISA2004 server to a web server. Currently there is a network connection that allows the web server to query the SQL database and pass its information back to the web server and display is content on our website. Now I need to move our web server into a DMZ and allow this data pass between each other via ISA2004. Not that this is a ISA forum but I created my rule that should allow this data to pass but its some how being blocked. I dont think the problem is within ISA.

Is there any place within SQL that I would be able to log requests to its database or is there security within SQL that could be blocking this data.

Wayne

 

[mrdenny]

There is no security that would be blocking this. Try to telnet from the web server to port 1433 on the sqlserver. If you can not connect then you have a firewall problem.

You need TCP 1433 open from the web server to the SQL Server. You may also need UDP 1434 open, but you shouldn't.

Denny

--Anything is possible. All it takes is a little research. (Me)