Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3400
  • Last Modified:

Quickbooks 2012 Database Server Manager can't get multi user working

Was hosting quickbooks on a workstation but then I installed QuickBooks database server manager on a server and copied the company files to the server.   Ran the scan on server and it found the files.  When I try and connect more than one user it says it is not in multi user mode.  The documentation says that when the scan is done it would put the files in multi user mode.  Have not found much documentation on database server manager and multi user mode.  I did not install QuickBooks on the server only the database server manger software.  Any ideas how to get this configuration working?  Thanks.
0
gseales
Asked:
gseales
  • 6
  • 4
3 Solutions
 
John HurstBusiness Consultant (Owner)Commented:
Check to see if QuickBooks is still in Hosted mode. If so, this needs to be changed.

First, make sure there are not ledgers (company files) on personal computer (you moved the company files to the server). Make sure you moved the .QBW file and the .TLG file. DSN and ND files will remake themselves and should not be move.

Now open QuickBooks and CLOSE any open file so that QuickBooks is running but no file is open. Go to the large center window and choose Open Company File. Navigate to the server location and open the company file. The purpose this is to avoid Recent Files which can confuse things.

Once the company file is opened, go File, Utilities and ensure Host Multi User Access is NOT checked. Then go File, Switch to Multi User Mode. Make sure this works.

Now follow the same method for each QuickBooks client.

Also make sure you are using mapped drivers to the server and not browsed drives.
0
 
John HurstBusiness Consultant (Owner)Commented:
Hello gseales - Did you disable Host Multi User access?  And did that help?

Thanks.
0
 
gsealesProduction ManagerAuthor Commented:
Hi John,

Sorry it has been so long, I never had a chance to make it over there and try this.  I did everything you said, but get a message when I try and switch it to Multi-User mode.  

"Problem: The company file is located on another computer and QuckBooks cannot contact that computer."  Error code: H202.

"Solution: Fix the hosting setup.  Recommended: On the computer where the file is located verify that QuickBooks is set up to host multi-user access"

Before I copied the files from the workstation to the server, I did check under "File" and it is on "Switch to Multi-User Mode"

Any idea what I did wrong?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
John HurstBusiness Consultant (Owner)Commented:
The problem and error code you are getting can result from having the Company File on a different physical partition than the Server Manager. Make sure both Server Manager and Company file are on the same partition (say C:) on the Server.

Make sure you do this and have a good backup of the Company file.

Then delete local copies of the file.

Then try again.
0
 
gsealesProduction ManagerAuthor Commented:
Will give that a try and let you know how it goes.
0
 
gsealesProduction ManagerAuthor Commented:
Still had same error message.  One other thing that I did not include in the error message before was the last thing:

File: Q:\CompanyNameInc.QBW
Disk is attached to 192.168.1.102
Running on Server:  \\Server\QuickBooks\CompanyName.QBW
    (, port not available)

Do I need to allow some port on the server and or clients?
0
 
gsealesProduction ManagerAuthor Commented:
I added the ports 8019, 56722, 55348 to the server and client firewalls and it worked switching to multi user mode now.  Probably was the problem all along.  Anyway thank you for all you help.
0
 
John HurstBusiness Consultant (Owner)Commented:
Thanks for the update. I do not normally have to adjust ports to make QuickBooks share files properly, but I am glad it worked for you.
0
 
gsealesProduction ManagerAuthor Commented:
.
0
 
gsealesProduction ManagerAuthor Commented:
In the end this was the final piece that made this work.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now