Solved

ISA 2004 denied connection to SQL database

Posted on 2006-11-15
2
587 Views
Last Modified: 2008-02-01
We are running a SBS 2003 Premium Edition server and are getting intermittent denied connections when our SQL database is queried.

When using the ISA 2004 Monitoring tool I get successful connections to port 21100 and then get several denied connections.  The rule field of the log is blank for the denied connections.  The "Error Information" field shows 0x0 and the "Result Code" Field shows 0x80074e23.

Thanks
0
Comment
Question by:insonline
2 Comments
 
LVL 51

Accepted Solution

by:
Keith Alabaster earned 250 total points
ID: 17950361
Should have a rule in the ISA allowing all outbound FROM local host & internal TO local host & internal.

The error code is stating that you have exceeded your connection limit or you have exceeded a quota setting. How many licences do you have on the SBS server?

http://www.microsoft.com/technet/isa/2004/plan/connectionlimits.mspx
http://www.microsoft.com/technet/isa/2004/plan/logging-best-practices.mspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/isasdk/isa/error_codes.asp
0
 

Author Comment

by:insonline
ID: 17956305
Increased the connection limits and the problem was solved.

Thanks!!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Do you have a windows based Checkpoint SmartCenter for centralized Checkpoint management?  Have you ever backed up the firewall policy residing on the SmartCenter?  If you have then you know the hassles of connecting to the server, doing an upgrade_…
The DROP (Spamhaus Don't Route Or Peer List) is a small list of IP address ranges that have been stolen or hijacked from their rightful owners. The DROP list is not a DNS based list.  It is designed to be downloaded as a file, with primary intention…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now