compsol1993
asked on
Quickbooks Disconnects
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?
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?
Do you get the message "connection has been lost"?
Check the page http://quickbooksconnectionlost.com
ASKER
Thanks for both of your responses. I should have been clearer, we are not using mapped drives at all now, and the problem is still happening.
When opening a file for the first time, we go File -> Open and browse to the server, and open the file from the share.
Yes we did get the message that "Connection has been lost". i took a look at that site, and tried everything, though we still haven't gotten to the bottom of the problem.
Thanks
When opening a file for the first time, we go File -> Open and browse to the server, and open the file from the share.
Yes we did get the message that "Connection has been lost". i took a look at that site, and tried everything, though we still haven't gotten to the bottom of the problem.
Thanks
Thanks for the update.
First: I have been using QuickBooks from V2003 through V2010 on Server 2003 across about a half dozen clients. In all that time, with a single exception (which was fixed), QuickBooks has never lost its connection.
So I would say the probability is greater than 95% that this is a server, network, or computer infrastructure problem and not QuickBooks.
Now with respect to your latest post, I think you should be using mapped drives with full name convention (NET USE Z: \\servername\qbfolder). I know you said you did in your first post.
The only QB thing I can think of here (and may be a question for Intuit Support) is: Is the version of Server Manager the same for QB Enterprise as for QB Premier. The two server managers may have to be separated to correct your problem.
... Thinkpads_User
First: I have been using QuickBooks from V2003 through V2010 on Server 2003 across about a half dozen clients. In all that time, with a single exception (which was fixed), QuickBooks has never lost its connection.
So I would say the probability is greater than 95% that this is a server, network, or computer infrastructure problem and not QuickBooks.
Now with respect to your latest post, I think you should be using mapped drives with full name convention (NET USE Z: \\servername\qbfolder). I know you said you did in your first post.
The only QB thing I can think of here (and may be a question for Intuit Support) is: Is the version of Server Manager the same for QB Enterprise as for QB Premier. The two server managers may have to be separated to correct your problem.
... Thinkpads_User
Have you checked the server auto-disconnect?
http://support.microsoft.com/kb/297684
See if this helps you. This has helped me with issues in the past.
http://support.microsoft.com/kb/297684
See if this helps you. This has helped me with issues in the past.
You should be able to go to the PHP5 install path, modify the config settings to include FTP (look for a php_config file), then run your normal
./configure
make
make install
There is data damage/corruption in your data file that is causing the error. Get you file analysed for free by looking up "Quickbooks File Repair" on Google. If corrupted, it costs $300 to fix.
ASKER
We noticed something else interesting today, our user came back to her PC after leaving it idle for a couple of hours and found Quickbooks had disconnected again.
She also noticed that all network access was down for 30 seconds. She could not access shared folders via explorer. Her desktop is also mapped to the server, and it was empty. Then 30 seconds later, everything started showing up.
Zilliontech: thanks for your response, but we have about 20 different Quickbooks files (all for different properties), and all do it.
She also noticed that all network access was down for 30 seconds. She could not access shared folders via explorer. Her desktop is also mapped to the server, and it was empty. Then 30 seconds later, everything started showing up.
Zilliontech: thanks for your response, but we have about 20 different Quickbooks files (all for different properties), and all do it.
You have a network card/network issue then. I've seen this before.....the user loses connection momentarily and then it self-resolves. You need to look at the design of your network and identify the problem. Nobody here can help you with that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Thank you, and I hope you were able to resolve the network issue. ... Thinkpads_User
You should use full paths as you showed. That was a good move. Try running a script to disconnect drives when the client machines log off or disconnect. Make sure the drives are not persistent. NET USE Z: /persistent:NO
Given that, make sure all client machines have properly cleared any mapped drives, restart, map the drives, start QuickBooks. Now, when you start QuickBooks, do not load a ledger. Close the company and start again. Using the Open Existing Company button (not the remembered drive), open a ledger.
See if this does anything. I am responding to you saying that not all users are disconnecting now that you are mapping with full paths.
... Thinkpads_User