Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

PIX 6.3 SQL Server does not exist or access denied connecting to local ip

We just installed a new pix 6.3 last weekend and all of sudden we are getting what appears to be timeouts on occasion when an asp page tries to connect via a dsn to a sql server. The dsn is pointing to a local 192 ip address. The problem seems to happen more frequently later at night when traffic is light.
0
aaronvest
Asked:
aaronvest
  • 3
1 Solution
 
Tim HolmanCommented:
More details please.  Could you explain the architecture a litle more ?  Where's the SQL server, where's the WWW server ??
0
 
aaronvestAuthor Commented:
We are behind the pix with one-to-one. 192.168.2.0 local network. Both machines are behind the firewall.
0
 
Tim HolmanCommented:
What does 'show conn' say when you're experiencing this problem ?
You should be on PIX v6.3(3) - there were a few bugs with 6.3(1) that may be affecting things.
Are there any error messages on the SQL box ?
What error is the .asp user presented with ?
Is the SQL connection set to time out on the SQL server, or does the .asp page expect the DSN to be 'open' for exclusive use for x minutes ?

0
 
Tim HolmanCommented:
How was this resolved?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now