Understanding QuickBooks Database Server Manager: A Guide for Dev

Welcome Dev, as a business owner or an accountant, it is essential to stay organized with your financial data to ensure the success of your business. QuickBooks is one of the most popular accounting software that can help you efficiently manage your finances. In this article, we will be discussing QuickBooks Database Server Manager and its functions. Let’s dive into the world of QuickBooks!

What is QuickBooks Database Server Manager?

QuickBooks Database Server Manager is a tool provided by QuickBooks that allows users to manage multi-user access to the company file. It creates network data files (.nd) for any company files that are stored on the host computer. This tool is used to share the company files with other users over the network, and it also helps optimize QuickBooks performance when multiple users are accessing the company file at the same time.

How to install QuickBooks Database Server Manager?

Before we discuss the installation process, make sure that the host computer fulfills the system requirements to install QuickBooks Database Server Manager. Once you have verified that, follow these steps to install the tool:

Step
Action
Step 1
Download QuickBooks Desktop and save the installation file on the host computer.
Step 2
Open the installation file and click on “Next” to start the installation process.
Step 3
Read the software license agreement and accept it to continue.
Step 4
Choose the “Custom and Network Options” installation type and click on “Next”.
Step 5
Select the “Server” option as the installation type and click on “Next”.
Step 6
Choose the installation location and click on “Install”.
Step 7
Wait for the installation to complete and click on “Finish”.

How to set up QuickBooks Database Server Manager?

After the installation is complete, you will need to set up QuickBooks Database Server Manager to use it. Here are the steps to follow:

Step
Action
Step 1
Launch QuickBooks Database Server Manager.
Step 2
Click on the “Scan folders” tab to select the folders where the company files are stored.
Step 3
Click on the “Scan” button to start the scanning process for the company files.
Step 4
Once the scanning is complete, click on the “Monitored Drives” tab and ensure all the folders with company files are listed here.
Step 5
Click on the “Database Server” tab and ensure that the “Database Server: Running” status is displayed.

How to use QuickBooks Database Server Manager?

Now that you have successfully installed and set up QuickBooks Database Server Manager, let’s discuss how to use it. Here are some of the functionalities of this tool:

Add/Remove Users

QuickBooks Database Server Manager allows you to add or remove users that can access the company file over the network. Follow these steps to add or remove users:

Action
Step
Add Users
1. Open QuickBooks Database Server Manager and click on the “Database Server” tab.
2. Click on the “Add Folder” button to add a new folder.
3. Browse and select the folder that contains the company file that you want to share.
4. Once the folder is added, click on the “Scan” button to scan for the company file.
5. Click on “Close” to exit the window.
Remove Users
1. Open QuickBooks Database Server Manager and click on the “Database Server” tab.
2. Click on the “Remove Folder” button next to the folder you want to remove.
3. Click on “Yes” to confirm the removal.
READ ALSO  SFTP Server Host Key: Your Ultimate Guide to Understanding and Managing It

View Company File Status

QuickBooks Database Server Manager allows you to view the status of the company file that is being accessed by other users. Follow these steps to view the status:

Step
Action
Step 1
Open QuickBooks Database Server Manager and click on the “Database Server” tab.
Step 2
Click on the “Open Ports” button to view the status of the company file.

Update QuickBooks Database Server Manager

It is essential to keep QuickBooks and its associated tools up-to-date to ensure smooth functioning. Follow these steps to update QuickBooks Database Server Manager:

Step
Action
Step 1
Open QuickBooks and click on the “Help” menu.
Step 2
Click on “Update QuickBooks” and select “Update Now”.
Step 3
Select “Get Updates” to start the update process.

FAQs about QuickBooks Database Server Manager

1. What is the role of QuickBooks Database Server Manager?

QuickBooks Database Server Manager allows multiple users to access the company file over the network while optimizing QuickBooks performance.

2. What are the system requirements for QuickBooks Database Server Manager?

QuickBooks Database Server Manager requires Windows 10, Windows 8.1, Windows Server 2019, Windows Server 2016, or Windows Server 2012 R2.

3. Can I use QuickBooks Database Server Manager without installing QuickBooks?

No, QuickBooks Database Server Manager is a tool provided by QuickBooks and requires QuickBooks Desktop to be installed on the host computer.

4. Can I add or remove a user while they are accessing the company file?

No, you cannot add or remove a user while they are accessing the company file. You will need to inform them to log out first before making any changes.

5. How often should I update QuickBooks and its associated tools?

You should update QuickBooks and its associated tools whenever a new update is available. This will ensure smooth functioning and avoid any performance-related errors or issues.

Conclusion

QuickBooks Database Server Manager is a valuable tool for any business owner or accountant who wants to share their company file with other users over the network. This tool can help optimize QuickBooks performance while allowing multiple users to access the company file. We hope this article has provided you with a better understanding of QuickBooks Database Server Manager and its functions. If you have any further queries, feel free to reach out to QuickBooks support for assistance.