- Nov 5, 2018
- 2,495
- 2,064
So I set up this pretty simple Quickbooks multi user setup, as simple as I could. 4 users total.
4 workstations, one server all running Win 7 pro, QB Enterprise 2011.
It ran well for a few years, now there's problems with multi hosting on the server. Currently when a workstation attempts to switch to multi user mode, Quickbooks says there's communication error which is BS, I have gone as far as disabling all firewalls and every user has full Windows permissions for the data file.
Now what happened I think is one user had a problem with multi user access a short time ago, the server may have been doing a restart after updates, other network intermittent glitches, whatever but it a only momentary thing. So this Einstein went into quickbooks and turned on the option to host a multi-user data file on that system. For reasons of back-up and data integrity I host the data on a stand-alone server.
Now the fun and games begin. So instantly users were still loading the data file from the server but were prevented from switching to a multi-user mode. I suspect Quickbooks is confused as it was told to host a multi-user data file in two places so it refuses to enter multi-user mode. Now you would think the simple act of disabling the multi-user/host file on a workstation would fix things, but no.
I have gone as far as deleting the config files on the server and letting another workstation rebuild them, doing a revo uninstall on the system that was wrongly designated as a host system, nothing works. So Quickbooks is hiding this database hosting info somewhere that I can't easily figure out.
I am left with three alternatives 1. someone here knows the magic sauce to fix the database permissions 2. I call Intuit and find out what's happening but I don't even know if they support the 2011 version or how much they will charge me, either way that's total BS. 3. I reverse engineer the Quickbooks and find out exactly what's going on. If I do that I am pissed, it's going to take a lot of time and if that's the case, Inuit is not going to be happy about it in one way or another.
So can anybody help a brother out?
4 workstations, one server all running Win 7 pro, QB Enterprise 2011.
It ran well for a few years, now there's problems with multi hosting on the server. Currently when a workstation attempts to switch to multi user mode, Quickbooks says there's communication error which is BS, I have gone as far as disabling all firewalls and every user has full Windows permissions for the data file.
Now what happened I think is one user had a problem with multi user access a short time ago, the server may have been doing a restart after updates, other network intermittent glitches, whatever but it a only momentary thing. So this Einstein went into quickbooks and turned on the option to host a multi-user data file on that system. For reasons of back-up and data integrity I host the data on a stand-alone server.
Now the fun and games begin. So instantly users were still loading the data file from the server but were prevented from switching to a multi-user mode. I suspect Quickbooks is confused as it was told to host a multi-user data file in two places so it refuses to enter multi-user mode. Now you would think the simple act of disabling the multi-user/host file on a workstation would fix things, but no.
I have gone as far as deleting the config files on the server and letting another workstation rebuild them, doing a revo uninstall on the system that was wrongly designated as a host system, nothing works. So Quickbooks is hiding this database hosting info somewhere that I can't easily figure out.
I am left with three alternatives 1. someone here knows the magic sauce to fix the database permissions 2. I call Intuit and find out what's happening but I don't even know if they support the 2011 version or how much they will charge me, either way that's total BS. 3. I reverse engineer the Quickbooks and find out exactly what's going on. If I do that I am pissed, it's going to take a lot of time and if that's the case, Inuit is not going to be happy about it in one way or another.
So can anybody help a brother out?