Host Multi-user access and Database Server Manager (DBSM)

  • 1
  • Question
  • Updated 4 years ago
  • Answered
What's the difference between these two processes and is it important?

The QuickBooks Database Server Manager (DBSM) is a process that is installed on a computer 
(usually the server) on which the company file physically resides but itself does not have a 
Quickbooks / Accounts Business application installed.  Its function is to manage multi-user access to the company file.  

The DBSM is actually a part of the QuickBooks/Accounts Business application turned into a standalone utility.  This utility is installed by choosing the Company File Server Only option during installation. 

Host Multi-User Access is a process that in a  networked environment activates the management of multi-user access to the company file by the installation on this PC.  It will do the same job on a PC with QuickBooks/Accounts Business installed that the DBSM does on the server.

You install the DBSM in a client/server network.   However, in a Peer to Peer network where there 
is no standalone server, you can use the DBSM within the installation on the PC on which the file 
resides – the Host PC.  You can turn it on either by installing with the option QuickBooks and 
Company File Server, or by File > Utilities > Host Multi-user access.  

On all other PC’s install Quickbooks / Accounts Business with the installation option Quickbooks Only.





Usage has shown that it is easy for a network to acquire two sources of hosting multi-user access – the server with its DBSM and a PC that has activated hosting multi-user access.  The main symptom of this arrangement is a company file that takes many minutes to open.  You may also find that it takes a little longer for inputs to save to the file.  

After a few weeks of a slow opening file it may fail to open at all and you get an error something like: “You are trying to work with a company file that is located on another computer, and this copy of QuickBooks cannot reach the server on that computer. (H202)”.  

Were a third computer to start hosting multi-user access then immediately you will not be able to access the company file. 

The solution is to stop hosting multi-user access on all PCs other than the server or Host PC.


 

Attention to this detail of only one computer hosting multi-user access will ensure your network runs efficiently.  


regards,
John
Photo of Reckon FAQs

Reckon FAQs, Employee

  • 9,988 Points 5k badge 2x thumb

Posted 4 years ago

  • 1

There are no replies.

This conversation is no longer open for comments or replies.