What is QuickBooks Database Server Manager? How can I download, install, and update it?
QuickBooks is an accounting software developed by Intuit that helps businesses manage their financial transactions. The software comes in different versions, including QuickBooks Desktop, QuickBooks Online, and QuickBooks Enterprise. The QuickBooks Desktop version is designed to be installed on a computer or a server, while QuickBooks Online is cloud-based.
One of the key features of QuickBooks Desktop is the ability to host the company's data file on a server, which allows multiple users to access the file simultaneously. To enable this feature, users need to install the QuickBooks Database Server Manager, which is a tool that helps manage the company's data file on a server.
In this blog, we will discuss how to download and install the QuickBooks Database Server Manager.
What is QuickBooks Database Server Manager?
The QuickBooks Database Server Manager is a tool that allows users to host their QuickBooks company file on a server, so multiple users can access it at the same time. It creates a network data file (.ND) for the company file, which allows QuickBooks Desktop to communicate with the server.
The QuickBooks Database Server Manager is installed automatically when users install QuickBooks Desktop on their computer or server. However, if users need to install the tool on a different server or want to update it to the latest version, they need to download and install it separately.
Downloading QuickBooks Database Server Manager
To download the QuickBooks Database Server Manager, users need to follow these steps:
Step 1: Visit the Intuit website
The first step is to visit the Intuit website at https://quickbooks.intuit.com/. Users can choose to sign up for a new account or log in to their existing account.
Step 2: Choose the QuickBooks version
Once users are logged in, they need to choose the QuickBooks version they want to download the Database Server Manager for. The website will display the available versions of QuickBooks, including QuickBooks Desktop Pro, QuickBooks Desktop Premier, and QuickBooks Desktop Enterprise.
Step 3: Download the Database Server Manager
After choosing the QuickBooks version, users can download the Database Server Manager by clicking on the "Download" button. The website will display the download link for the Database Server Manager.
Step 4: Install the Database Server Manager
Once the download is complete, users need to install the Database Server Manager on the server where the company file is stored. The installation process is straightforward and takes only a few minutes to complete.
Installing QuickBooks Database Server Manager
To install the QuickBooks Database Server Manager, users need to follow these steps:
Step 1: Close all running programs
Before installing the Database Server Manager, users need to close all running programs, including QuickBooks Desktop.
Step 2: Download the Database Server Manager
Users need to download the QuickBooks Database Server Manager from the Intuit website by following the steps mentioned above.
Step 3: Install the Database Server Manager
Once the download is complete, users need to run the installer file and follow the on-screen instructions to install the Database Server Manager.
Step 4: Choose the installation type
The installer will display two installation types: Typical and Custom. Users can choose the Typical installation type, which installs the Database Server Manager in the default location, or the Custom installation type, which allows users to choose the installation location.
Step 5: Agree to the license agreement
Users need to read and accept the license agreement to proceed with the installation.
Step 6: Choose the installation location
If users choose the Custom installation type, they need to choose the installation location for the Database Server Manager.
Step 7: Complete the installation
After choosing the installation type and location, users can complete the installation by clicking on the "Install" button. The installer will install the Database Server Manager on the server.
Configuring QuickBooks Database Server Manager
After installing the QuickBooks Database Server Manager, users need to configure it to enable multi-user access to the company file. To configure the Database Server Manager, users need to follow these steps:
Step 1: Users can open the QuickBooks Database Server Manager by clicking on the Windows "Start" button and selecting "QuickBooks Database Server Manager" from the list of installed programs.
Step 2: Add the company file
Once the QuickBooks Database Server Manager is open, users need to click on the "Scan Folders" tab and add the folder where the company file is stored. The tool will automatically detect the company file and create a network data file (.ND) for it.
Step 3: Monitor the company file
Users can monitor the status of the company file by clicking on the "Database Server" tab. The tool will display the status of the company file, including the number of users accessing it and the status of the network data file.
Step 4: Allow access to the company file
Users need to ensure that the company file is accessible to other users by configuring the firewall and permissions settings. They can do this by following the steps mentioned below:
a. Configure firewall settings: Users need to ensure that the QuickBooks ports are open on the server firewall. The QuickBooks Database Server Manager uses ports 56728, 55368-55372, and 80 for communication. Users can add these ports to the firewall settings to allow access to the company file.
b. Configure permissions settings: Users need to ensure that the folder where the company file is stored has the appropriate permissions for other users to access it. They can do this by sharing the folder and giving read and write permissions to other users.
Conclusion
The QuickBooks Database Server Manager is a useful tool that enables businesses to host their company file on a server and allows multiple users to access it simultaneously. Installing and configuring the tool is easy, and users can do it in a few simple steps. By following the steps mentioned in this blog, users can download, install, and configure the QuickBooks Database Server Manager to enable multi-user access to the company file.

Comments
Post a Comment