gseales
asked on
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Will give that a try and let you know how it goes.
ASKER
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\Compan
(, port not available)
Do I need to allow some port on the server and or clients?
File: Q:\CompanyNameInc.QBW
Disk is attached to 192.168.1.102
Running on Server: \\Server\QuickBooks\Compan
(, port not available)
Do I need to allow some port on the server and or clients?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
.
ASKER
In the end this was the final piece that made this work.
Thanks.