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?  
compsol1993Asked:
Who is Participating?
 
JohnConnect With a Mentor Business Consultant (Owner)Commented:
"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."

That was the "server, network, or computer infrastructure problem" I was referring to. The problem you describe (where Explorer can reconnect) plays havoc with QuickBooks. It disconnects and game over until you restart the ledger.

You now have to try to nail down what the network issue is. ... Thinkpads_User
0
 
JohnBusiness Consultant (Owner)Commented:
I have been running QuickBooks with ledgers on a server and only ever saw this at one client. It was a server problem. The server was replaced (for other reasons) and the problem vanished. At other clients, QuickBooks will stay connected all day long.

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
0
 
ZillionTechCommented:
Do you get the message "connection has been lost"?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
ZillionTechCommented:
0
 
compsol1993Author Commented:
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
0
 
JohnBusiness Consultant (Owner)Commented:
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
0
 
kennyhenaoCommented:
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.
0
 
theodorejsalvoCommented:
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

Open in new window

0
 
ZillionTechCommented:
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.
0
 
compsol1993Author Commented:
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.  
0
 
ZillionTechCommented:
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.
0
 
compsol1993Author Commented:
Thanks
0
 
JohnBusiness Consultant (Owner)Commented:
Thank you, and I hope you were able to resolve the network issue. ... Thinkpads_User
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.