SQL Connection Slow In DMZ

[jswencki]

We have an issue where our asp.net app connects to sql 2000 in a DMZ
through a pix router. There is no ACL(Access Control List) in place,
so 1433 is allowed. It connects, but very slowly, 5 seconds to return
page. When on the same side of the wall, it is 1.5 seconds. Is there
a SQL setting or ASP connection string setting or known issue with
this scenario.

I would appreciate any assistance on this as we are pretty much
stumped. We have tried new cards, cables, physical ports, etc to get
this to work, but no luck.

Thanks for your responses!

[bruce barker]

do a network packet trace and you will probably find some timeout
packets (kerberos authentication timeouts are common).

for a quick test, switch to tcp/ip only and standard security.

-- bruce (sqlwork.com)
js******@gmail.com wrote:

We have an issue where our asp.net app connects to sql 2000 in a DMZ
through a pix router. There is no ACL(Access Control List) in place,
so 1433 is allowed. It connects, but very slowly, 5 seconds to return
page. When on the same side of the wall, it is 1.5 seconds. Is there
a SQL setting or ASP connection string setting or known issue with
this scenario.

I would appreciate any assistance on this as we are pretty much
stumped. We have tried new cards, cables, physical ports, etc to get
this to work, but no luck.

Thanks for your responses!