Query through a firewall

We have a SQL 2000 database sitting behind a CheckPoint firewall. The server
host our HelpSTAR helpdesk
database. Clients connect to the database from their workstation with the
HelpSTAR client. All the proper ports
are open to allow communication through the firewall between client and
workstation. We have several reports
that will not run. When I execute the following query I get the response
desired.
"SELECT * from tblrptfiles where id = 11"
When I run the same query but for a different id # it fails after about 30
seconds with the listed error message.
"SELECT * from tblrptfiles where id = 24"
Error message
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForD
ata
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
If I run the same query that failed from a machine in the same subnet
without the firewall between them it works. Keep in mind that my query works
with the firewall inplace if I ask for a different id. If I run the query
with an ID that is not in the table it works, also the ID I am asking for
does exist in the table. Any ideas on what would be causing this?
Thanks.This is a weird one. Are you sure it's not just different machines
requesting a different set of ID's? Have you made sure all the clients and
SQL Server are using the latest MDAC?
--
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"Tubbaguts" wrote:

> We have a SQL 2000 database sitting behind a CheckPoint firewall. The serv
er
> host our HelpSTAR helpdesk
> database. Clients connect to the database from their workstation with the
> HelpSTAR client. All the proper ports
> are open to allow communication through the firewall between client and
> workstation. We have several reports
> that will not run. When I execute the following query I get the response
> desired.
> "SELECT * from tblrptfiles where id = 11"
> When I run the same query but for a different id # it fails after about 30
> seconds with the listed error message.
> "SELECT * from tblrptfiles where id = 24"
> Error message
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckFo
rData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken
> If I run the same query that failed from a machine in the same subnet
> without the firewall between them it works. Keep in mind that my query wor
ks
> with the firewall inplace if I ask for a different id. If I run the query
> with an ID that is not in the table it works, also the ID I am asking for
> does exist in the table. Any ideas on what would be causing this?
> Thanks.|||We discovered our issue with this query through the firewall late yesterday.
Our Check Point firewall also has an intrusion prevention running and the
firewall was seeing this query and one other as being a SQL exploit. Once we
allowed this query through everything worked again.
"MeanOldDBA" wrote:
[vbcol=seagreen]
> This is a weird one. Are you sure it's not just different machines
> requesting a different set of ID's? Have you made sure all the clients an
d
> SQL Server are using the latest MDAC?
> --
> MeanOldDBA
> derrickleggett@.hotmail.com
> http://weblogs.sqlteam.com/derrickl
> When life gives you a lemon, fire the DBA.
>
> "Tubbaguts" wrote:
>