Avatar of Bullfrog28
Bullfrog28
 asked on

Quickbooks database server manager problems.

I'm having a lot of problems with QB data files stored on Win Server 2012 and 2012 R2 across a variety of clients.

I constantly have to stop the DNS and Windows Firewall services, run the DB Server manager to scan the files, then start DNS and Firewall.  If I dont stop those services the scan fails saying the firewall is blocking the manager.

All proper ports are allowed through the firewall.

Really dont know what to do anymore.  Qb support is absolutely no help.
QuickBooksDNSWindows Server 2012Windows Networking

Avatar of undefined
Last Comment
masnrock

8/22/2022 - Mon
masnrock

Which version of Quickbooks? (Let's start with one client, then we can start to discuss others)
Bullfrog28

ASKER
Ok the easy client, version 2016.  2 desktops, datafile hosted on Win Server 2012.
masnrock

So to confirm, these ports are open on the server: 8019, 56726, 55368-55372

And you also don't have either of the workstations trying to act as the machine to share? (I've seen that be a major screw up before)

Also, what else is running on the server?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Bullfrog28

ASKER
Yes, confirmed all of those ports are open

It's their Domain Controller and file server.
masnrock

Sounds about right. I'm guessing that Quickbooks is in its own share... What AV is running on the server?
Bullfrog28

ASKER
Yes it's in it's own share.

AV: ESET File Security for Microsoft Windows Server
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
masnrock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Bullfrog28

ASKER
I'll take a look, I doubt that was done.  I'll add the exception and test.

Will let you know tomorrow.

Thanks.
John

QB 2016 works fine on Server 2012 with the QB Server Manager. We use Symantec Endpoint Protection. We had to make exclusions for QB, so try that here as suggested above.
Bullfrog28

ASKER
I put the exclusion in and this morning the users seem to be operating fine.  Multiuser and switching db files is working without having to re-scan and restart the services.

Now here's the monster.....

Another client is an accounting firm.  They use QB 2008 through to 2017.  They are constantly experiencing the same issue.  There are literally hundreds of customer datafile's in different directories.

Do I need to be running the every version of the DB server manager or should the most current just work?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SOLUTION
masnrock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
John

You should only have ONE server manager on the server. The newest version will work backward though quite a few versions, but to V2008? I am not certain. It is out of support anyway.

So encourage your clients to get up to date.
ASKER CERTIFIED SOLUTION
masnrock

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
masnrock

Questions answered sufficiently