Thank you for your suggestions. Eric from AC tech support has been trying to fix the problem in the past one week with no luck. He uploaded and checked our SQL Amazingcharts primary data file(around 800MB) and condense the transaction log file from 300 down to 120MB. We reinstall the whole program in the server, problem persists. It happens randomly in both terminal server and the P2P clients. It seems that the total number of computers logging into the server and the TS client number approaches 28-30, the problem will comes up. We are sure that this is not our network or Windows license issues because we can access the other scanned data file in this server with no problem.
It really makes me wonder whether the SQL Express actually has a limit for the number of clients logging in at one time. Our IT said that there is also a 1GB data limit on the SQL Express and some how our primary data file increased from 600MB to 800MB after upgrading from V4 to V5. We might be forced to switch to other EMR when the data size is approaching 1GB. We really need some help!!
