We are using Windows Server 2003 for our SQL data with about 30 computer terminal. 8 computers are using Terminal Server and the other 22 are P2P with the server not using a Domain. We have frequent problems with connection to the data. The terminals were dropped in the middle of seeing a patient every day. We have turned off the firewalls. After going thru the diagnostic process, the error message in the Virtual IT is: " I couldn't stop the SQL Server Service. Frequently this is because Windows is in the middle of something and didn't respond in the time allotted. So please click the step 3 again and give it some more time."
We have learn the trick to connect again, but the problem continues every day. We are going to contact the AC support and see whether they can look at the error log inside our SQL server data base.
