Unanswered: Problem with Crystal Report connection to DB
I'm at a loss and don't know where to turn. If it's a DB resource problem, maybe posting a description here will get some fresh ideas. My apologies if I'm posting TMI or not enough.
Web user gets pop-up:
"CRAXDRD Error Occured on Server 20599. Cannot open SQL Server.".
This is limited to only 3 reports but it strangly goes away after a while. Until it goes away, no amount of repeated attempts will help (something seems "clogged" in the browser) but *sometimes* a client reboot fixes it. I think it might be DB related because I get reports from different users simultaneously then and from multiple web servers and the problem vanishes simultaneously. Most of the time that is.
At any given time, in EM I see about 10 - 20 processes "AWAITING COMMAND" status = "SLEEPING" all with my Crystal Report username. I'm wondering if this might be related.
Note: Off the shelf, Recrystalize wasn't cleaning up all it's web objects, now fixed. It's a script reports run after being generated "cleanup.asp".
Overall; the scheme works beautifully and has for 5 years - with this one glitch.
Question: How can I get more information on these processes, where they came from, why they're still hanging around, and am I approaching some system threshold from unreleased resources?