Hi guys! I did a bit of searching on my problem, but I haven't been able to find anything directly related, so I figured I'd post it here.
Currently, we have Amazing Charts 6.1.2 installed on a central server running Server 2k3 SBS. We have about a dozen machines (75% Windows 7 laptops, 25% XP desktops) connecting up, all with 6.1.2 installed as well.
Every so often, all of the connections to the AC database on the server drop (such as twice last Friday, 7/27, a few times that week, and maybe once a couple weeks before that). The only way to bring everything back up is to go into Amazing Utilities and choose to 'Repair Connection'. Running 'Check Amazing Charts' shows an error under 'Database Definition Check' for a detached database.
While going through the server event logs, I came across some interesting entries leading up to the failure. It usually starts off with a single machine showing informational events about it stopping a number of processes (usually a couple dozen, as if it's shutting down):
![[Linked Image from ]](/ub/attachments/usergals/2012/07/full-3895-327-process.jpg)
After that, three errors occur, stating:
![[Linked Image from ]](/ub/attachments/usergals/2012/07/full-3895-328-three_errors.jpg)
Followed by
![[Linked Image from ]](/ub/attachments/usergals/2012/07/full-3895-329-database.jpg)
After that, the connection is dropped and I start to see failed login attempts by users, but dozens by the SQL root account 'SA' (which I know AC uses for database access)
![[Linked Image from ]](/ub/attachments/usergals/2012/07/full-3895-330-sa.jpg)
Only after I do the 'Repair Connection' do I stop seeing the logon attempts and start to see everything come back online. Once I see the informational events for "Starting up database 'AmazingCharts', everything is essentially back to normal.
I understand it's a bit of an odd issue, even more so since there doesn't seem to be any particular pattern to the failure. Have you guys seen anything like this before? Any possible causes for a dropped connection that you've seen in the past? I admit, I'm a bit new to working with Amazing Charts, so it may be that my information above is irrelevant. Let me know if there are any SQL or AC logs that can help!
Any help is appreciated!