SQL or ISA firewall problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello,
I have a problem and I do not know if it is a SQL problem or a ISA firewall
problem. I have two seperate SBS servers 'Server A' is a SBS 2000 and
'Server B' is a SBS 2003 and both have SQL 2000 installed on them. On a
workstation on 'Server B' I am running an application that is accessing the
SQL database on 'Server A' via ODBC. I can login on the application and do
between 5 or 6 transactions before I get a SQL connection error. While I am
doing the transactions I am running netstat in the background and when I see
the SYN_SENT that is when the connection error happens. If I disable the
ISA firewall client I can run transactions until the cows come home and not
have a SQL connection problem. Is this a SQL or a firewall problem?

The following is the netstat with the firewall
TCP 192.168.16.167:1800 192.168.16.2:55352 ESTABLISHED
TCP 192.168.16.167:1801 192.168.16.2:55354 ESTABLISHED
TCP 192.168.16.167:1802 192.168.16.2:55356 ESTABLISHED
TCP 192.168.16.167:1803 192.168.16.2:55358 ESTABLISHED
TCP 192.168.16.167:1804 192.168.16.2:55360 ESTABLISHED
TCP 192.168.16.167:1805 192.168.16.2:55262 SYN_SENT
TCP 192.168.16.167:2967 192.168.16.2:8080 CLOSE_WAIT

The following is the netstat with the firewall disabled.
TCP 192.168.16.167:1806 192.168.1.59:1433 ESTABLISHED
TCP 192.168.16.167:1807 192.168.1.59:1433 ESTABLISHED
TCP 192.168.16.167:1808 192.168.1.59:1433 ESTABLISHED
TCP 192.168.16.167:1809 192.168.1.59:1433 ESTABLISHED
TCP 192.168.16.167:1810 192.168.1.59:1433 ESTABLISHED
TCP 192.168.16.167:1811 192.168.1.59:1433 ESTABLISHED

I beleive the problem is with the firewall but I can not figure out what the
problem is or configure it. The only thing that make sense to me is that
the firewall thinks it is under attack. Any help would be apriciated.

Thank You,

Joe


.

Relevant Pages

  • Re: Security Problem...
    ... Your computer is listening on TCP 80. ... firewall is really blocking TCP 80, then maybe this isn't the case, or maybe ... If this was a compromise that came through IIS web services, ... secure a server, all mentioned in the links I gave you]. ...
    (microsoft.public.security)
  • Re: Verbindung zu SQL Server Express 2005 klappt nicht
    ... die Win Firewall ist trotz der Freigaben noch am ... Hab beim installieren diese SQL ... Was muss ich machen damit ich den SQL Server Express unter Vista Home ... Druckerfreigabe, TCP Port 1433, UDP Port 1434. ...
    (microsoft.public.de.sqlserver)
  • Re: SQL or ISA firewall problem
    ... It looks that ISA Server is not configured for the SQL Server port 1433 to ... > in the background and when I see the SYN_SENT that is when the connection ... > TCP 192.168.16.167:1800 192.168.16.2:55352 ESTABLISHED ...
    (microsoft.public.sqlserver.connect)
  • Re: Checkpoint Firewallregelwerk testen trotz Smart Defense
    ... Wenn ich mit ttcpw eine TCP Session aufbaue, ... Da du bei Checkpoint immer nur die Verbindungsaufbaurichtung per ... am Server ankommt. ...
    (de.comp.security.firewall)
  • dts komunikation zwischen 2 Netze über eine Firewall
    ... Ich habe eine Windowsanwendung die Daten auf einer MS ... Ein zweiter SQL Server, der ... auf der Firewall den Port 1433 bidirektional für die IP ... Trustedconnection an den SQL Server1, ...
    (microsoft.public.de.sqlserver)