I need to gain a deeper understanding into exactly what Database Server Manager is actually doing.
From reading the published information, I gather the following:
At the outset, it performs a 'scan' of the folder(s) containing company files in order to "ensure other computers can connect", as the GUI explains it.
I don't really need the program to "ensure" that. I know that if the remote computers can map a drive and see the company file, they have access, and I can set read/write access.
Per the article, the scanning process "shares all of your folders". That's a frightening thought. First of all, what kind of "share" is it ? A "simple" share ? An NTFS share ? What is the scope of "all of your folders" ? The folders specified in the scan ? The whole drive ?
Per the article, after the scan "you can now access the company files in these folders from other computers". The implication is that until then, you can't. Is that true ? Is it only true if you want to access it in muli-user mode ? Are all calls to the database running through the database server app ? Is it not possible to open the company file if the database server manager is not running ?
What is the implication of "monitored drives" ? Is the database manager actually tracking all file access on the drive ? Should the database folder be the only folder on the drive ?
A note in the article states that "you can't monitor mapped drives". What is inherently different about a mapped drive which makes it "unmonitorable" ?
The port monitor tab shows a number of conversations at different ports. What specific ports and ranges are required in order for Quickbooks to run ? Does it actually require all ports to be exposed ? That would be hugely unreasonable, especially in a firewalled network.
Operationally, there are several things I want to understand.
Is the database server manager multithreaded ? Does it benefit from being run on a "server" OS, which is optimized for multiple simultaneous access, as opposed to a desktop one ?
Informed answers are welcome. Generic or unspecific ones, not so much.
I appreciate you for posting your concern here in the Community. Let me share some insights about the Database Server Manager in QuickBooks Desktop.
The QuickBooks Database Server Manager help share your company files with other computers over your network. And yes, it's only applicable for Multi-user networks so your users can be able to access and work on the same company files as long as the Database Server Manager is running.
For more details about the Database Server Manager and to answer some of your questions, you can check these articles below:
As I posted above, uninformative responses are not welcome.
If you have genuinely useful information which addresses my questions in a specific way, as opposed to the meaningless drivel you quoted from manual copy or useless links to more of the same, then by all means post. If not, don't waste my time or the time of others who need to actually accomplish things.
Ensuring your questions about the Database Server Manager are addressed is my top priority.
Regarding your concern with the scanning process, it uses an NT File System (NTFS) share. This method changes the users' permission and QuickBooks to access the shared data file location which means it doesn't share the entire drive but the shared folder only.
On the other note, you can access the data file as long as you can open the file location. However, if you're on a muliti-user mode, you'll want to run the Database Manager to scan the file location.
About the monitored drives implication, the Database Manager only tracks the QuickBooks company files and location within the drive so you don't need to scan it again. Also, opened files using mapped drives or map a network drive can't be monitored since it doesn't use scan.