We have a server storing Quickbooks files and running the Quickbooks Database Server Manager.
This server stores both files for Quickbooks Enterprise 10.0 and Quickbooks Premier 2010. The new version of the Database Server Manager is running on the server (from the Premier 2010 CD). Its service is QuickbooksDB20. The server is a Windows 2003 SBS SP2 server. The clients are Windows 7 Pro 32-bit.
The problem is that the clients are finding Quickbooks will drop the connection to the server when left idle. For example, if Quickbooks is minimized for an hour, when you open it back up, it will have lost the connection to the server.
First we checked all clients and the server, and turned off power management on the network cards. This did not help the problem at all. Then we changed from using mapped network drives to full UNC paths (\\servername\qbshare\). This solved the problem for 2 weeks. Before doing this, the problem happened every day, then it disappeared.
Starting last week, the problem returned, and we are still using the UNC path. We are only noticing it with Premier files now, not Enterprise. And not all users are noticing it either, where before they all did.
Any suggestions on what we can do next?