QuickBooks Premier Pro 2013-Database connectivity drops

I have QuickBooks user that access the data base on a SBS 2008 network. I recently upgraded her from XP Pro to W7 Pro. She keeps looking connection to the QuickBooks Database from her workstation. The problem is intermittent, but happens several time a day.

I have disabled Ipv6, in the control panel and run the QuickBooks File Doctor tool successfully.

Any ideas? Thanks in advance.
mapalaska2003Asked:
Who is Participating?
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.

Alan HardistyCo-OwnerCommented:
Are you running the QB database sharing software on the SBS 2008 server?  If not, you need to be.
0
JohnBusiness Consultant (Owner)Commented:
Assuming the above point about the Server Manager, you also need to make sure Host Multi User Access is turned OFF on all QuickBooks clients.

Make sure you are using Mapped Drives to the server and not browsing for the folder.

In case the person is inadvertently looking for an incorrect "recent" file, close all QuickBooks Windows, and close the open file (if one is open) so that you get back the main navigation screen. Choose Open Company File and navigate to the folder containing the Company File.

.... Thinkpads_User
0
South ModModeratorCommented:
mapalaska2003,

I changed the zones for this question from

--Exchange Email Server
--Quickbooks Financial Software
--Miscellaneous Networking

to
--Quickbooks Financial Software
--Miscellaneous Networking
--Microsoft Server


SouthMod
Community Support Moderator
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Sudeep SharmaTechnical DesignerCommented:
IS the Windows Firewall on? Try turning it off and check if that solved the issue.

Sudeep
0
JohnBusiness Consultant (Owner)Commented:
It might be worth a try, but Windows Firewall can be on if no other firewall, or may supplanted by a third party firewall (SEP in my case) and it will be on.

.... Thinkpads_User
0
mapalaska2003Author Commented:
I've tried disabling the firewall, but that did not help. I was finally able to get a screenshot from the user. Perhaps this sheds a bit more light on the problem-Thanks.
QB-FULL.jpg
0
JohnBusiness Consultant (Owner)Commented:
What do you make of the first error. QB won't dole out this message unless the drive is full. Does the drive where the QB folder is located have errors?  That will cause it.

I gave you some suggestions in my post ID: 39505413 above. Can you answer the suggestions? Some of these suggestions address the second error message.

.... Thinkpads_User
0
mapalaska2003Author Commented:
The drive is only 1/3 full.

RE:ID: 39505413 above, Yes, we are opening the file as suggested.
0
JohnBusiness Consultant (Owner)Commented:
QB will not give a drive full error on a good drive with lots of space. Is there an error on the drive. CHKDSK in check mode only should tell you.

In my question, in addition to mapping drives, did you check the use of the Server manager, recent file use and whether you are using Host Multi User Access together with Multi User mode. The latter should not be done if using the Server Manager.

Do you know the connection to be solid. A flaky connection can cause QB to quit because it is a very chatty database. This has happened to me and at one client I have to run QB locally and sync the database back at the end of the session.

What you get has a physical cause. It is not an endemic QB problem.

... Thinkpads_User
0
mapalaska2003Author Commented:
I just moved the company file to the local machine, shared it, and have the user placing the backups on the server for now.
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
mapalaska2003Author Commented:
THANKS FOR THE SUGGESTIONS. I APPRECIATE IT.
0
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to assist.
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
QuickBooks

From novice to tech pro — start learning today.