SQL Connection Slow In DMZ

J

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top