Solved

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

Posted on 2014-02-20
10
3,179 Views
Last Modified: 2014-03-19
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
Comment
Question by:gseales
  • 6
  • 4
10 Comments
 
LVL 90

Assisted Solution

by:John Hurst
John Hurst earned 500 total points
ID: 39876603
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
 
LVL 90

Expert Comment

by:John Hurst
ID: 39881586
Hello gseales - Did you disable Host Multi User access?  And did that help?

Thanks.
0
 

Author Comment

by:gseales
ID: 39914775
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
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39914790
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
 

Author Comment

by:gseales
ID: 39926613
Will give that a try and let you know how it goes.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:gseales
ID: 39930552
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
 

Assisted Solution

by:gseales
gseales earned 0 total points
ID: 39930568
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
 
LVL 90

Expert Comment

by:John Hurst
ID: 39930911
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
 

Author Comment

by:gseales
ID: 39932609
.
0
 

Author Closing Comment

by:gseales
ID: 39939092
In the end this was the final piece that made this work.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now