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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
ZillionTechCommented:
0
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

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
JohnBusiness 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compsol1993Author Commented:
Thanks
0
JohnBusiness Consultant (Owner)Commented:
Thank you, and I hope you were able to resolve the network issue. ... Thinkpads_User
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
File Sharing Software

From novice to tech pro — start learning today.