The QuickBooks Database Server Manager (QBDSM) is an essential tool provided by Intuit, the makers of QuickBooks, to manage multi-user access to company files in QuickBooks Desktop. This utility allows multiple users to work on QuickBooks simultaneously, ensuring that the data is secure and accurately updated in real-time. QBDSM also helps you configure your network for multi-user mode, monitor your network and company files, and manage database servers.
This guide will walk you through everything you need to know about the QuickBooks Database Server Manager, including its download process, installation steps, key features, common issues, and solutions.
To help you fix this problem, we have some resources in this article. But if you need expert help, you can contact us anytime. We have a team of QuickBooks experts who are available 24/7 to assist you. Just call our support line at +1–833–526–3475.
What is QuickBooks Database Server Manager?
The QuickBooks Database Server Manager (QBDSM) is a tool that scans your computer for QuickBooks company files and ensures they are updated correctly. It creates a network data file for any company file stored on the host computer, allowing multiple users to access the file simultaneously in multi-user mode.
Here are some of the primary functions of QBDSM:
- Creates Network Data Files (.ND): The tool creates network data files for all QuickBooks company files located on the server computer.
- Monitors Company Files: It tracks the files being accessed by users to prevent data corruption and ensure proper file management.
- Updates Company Files: Automatically updates company files when there’s a QuickBooks software update, ensuring compatibility and security.
- Enables Multi-User Mode: Allows multiple users to access the same company file simultaneously, facilitating collaboration.
How to Download QuickBooks Database Server Manager?
Downloading QuickBooks Database Server Manager is a straightforward process. The tool is included with QuickBooks Desktop software but can also be downloaded separately if needed. Here are the steps to download QBDSM:
- Visit the Official Intuit Website: Go to the Intuit website and navigate to the QuickBooks Desktop section.
- Select Your Version: Choose the version of QuickBooks Desktop you are using (e.g., QuickBooks Desktop Pro, Premier, or Enterprise).
- Locate Database Server Manager Download: Find the section that offers the QuickBooks Database Server Manager download. It might be under "Additional Tools" or "Downloads."
- Download the Installer: Click the download link for the QuickBooks Database Server Manager. Save the installer to a location on your computer where you can easily access it.
- Run the Installer: Once the download is complete, run the installer and follow the on-screen instructions to install the tool.
How to Install QuickBooks Database Server Manager?
After downloading QBDSM, follow these steps to install it:
- Close All Applications: Ensure all other applications, especially QuickBooks Desktop, are closed before beginning the installation.
- Run the Installer: Locate the downloaded QBDSM installer file and double-click to run it.
- Follow On-Screen Instructions: The installation wizard will guide you through the process. Click “Next” to begin.
- Accept the License Agreement: Read through the license agreement and click “I accept the terms in the license agreement” before clicking “Next.”
- Choose Custom or Network Options: You will be prompted to choose between two installation types:
- Express (Recommended): Installs QBDSM in the default location.
- Custom or Network Options: Allows you to select a specific location or customize the installation settings.
- Select Install Type: Choose the option to install the database server only if the computer is solely used as a server. Otherwise, select the full program installation option.
- Complete the Installation: Click “Install” to begin the installation process. Once it’s complete, click “Finish” to close the installer.
- Restart Your Computer: Restart your computer to ensure all changes take effect.
Setting Up QuickBooks Database Server Manager
After installing QBDSM, you need to set it up to manage multi-user access properly. Here’s how to do it:
- Open QuickBooks Database Server Manager: Navigate to the QuickBooks program group in your Start menu or search for “QuickBooks Database Server Manager.”
- Scan Folders: Use the “Scan Folders” tab to add folders containing QuickBooks company files. Click “Add Folder” and navigate to the folder containing your company files. Click “OK.”
- Start Scan: After adding the necessary folders, click “Scan” to begin scanning. QBDSM will create network data files (.ND) for the company files.
- Verify the Status: Once the scan is complete, check the “Database Server” tab to ensure all company files are listed and accessible.
- Set Up Folder Permissions: Ensure that the folder containing QuickBooks company files has the correct permissions to allow users to access them. The QB Data Service User XX (where XX is your QuickBooks version) must have full control over these folders.
- Enable Multi-User Mode in QuickBooks: On each workstation, open QuickBooks and go to “File” > “Utilities” > “Host Multi-User Access.” Ensure this option is selected.
Key Features of QuickBooks Database Server Manager
- Multi-User Access: Enables multiple users to access the same company file simultaneously without data conflicts.
- Automatic Scanning and Monitoring: Monitors QuickBooks company files and ensures they are updated and secure.
- Firewall Configuration: Configures the firewall to allow QuickBooks-related communication between the server and workstations.
- Network Data Files Creation: Automatically creates network data files (.ND) to facilitate multi-user access.
- Performance Improvement: Enhances the performance of QuickBooks Desktop in a multi-user environment by efficiently managing company files.
Common Issues and Troubleshooting with QuickBooks Database Server Manager
Despite its utility, you might encounter issues when using QBDSM. Here are some common problems and their solutions:
1. QuickBooks Database Server Manager Not Running on the Server
Solution:
- Ensure that the QBDSM service is running on the server. You can check this by opening the “Services” window (press Windows + R, type services.msc, and press Enter), then locate the “QuickBooks DBXX” service (where XX represents your version).
- Right-click on the service and select “Start” if it’s not running. Set the startup type to “Automatic” to ensure it runs every time the server starts.
2. Unable to Switch to Multi-User Mode
Solution:
- Check network connectivity between workstations and the server.
- Ensure that QuickBooks is set to host multi-user mode on the server.
- Verify that the QBDSM is installed and properly configured on the server.
3. QuickBooks Company File Not Found on Server
Solution:
- Ensure that the folder containing the company file is added to the “Scan Folders” list in QBDSM.
- Confirm that the .ND file exists in the same location as the company file. If not, rescan the folder using QBDSM.
4. Firewall Blocking QuickBooks Database Server Manager
Solution:
- Configure the firewall settings to allow QuickBooks and QBDSM. Add exceptions for the QuickBooks ports and the QBDSM service.
5. Error 6000 Series When Opening Company File
Solution:
- These errors often indicate network issues. Use the “Database Server Manager” to scan the company file folder again.
- Ensure that all workstations and the server have the correct permissions to access the company file.
FAQs about QuickBooks Database Server Manager
What is QuickBooks Database Server Manager, and why do I need it?
QuickBooks Database Server Manager (QBDSM) is a tool that enables multiple users to access QuickBooks company files simultaneously in a networked environment. You need it to manage and monitor company files in multi-user mode effectively.
Can I install QuickBooks Database Server Manager on multiple computers?
Yes, you can install QBDSM on multiple computers. However, it should primarily be installed on the computer designated as the server (the computer hosting the company files).
How do I update QuickBooks Database Server Manager?
QBDSM is updated automatically when you update QuickBooks Desktop. However, if you need to update it manually, download the latest version from the Intuit website and run the installer.
What should I do if QuickBooks Database Server Manager stops working?
If QBDSM stops working, try restarting the server computer, ensuring the QuickBooksDBXX service is running, and checking for network connectivity and firewall settings.
Is QuickBooks Database Server Manager free to use?
Yes, QBDSM is free to use. It comes bundled with QuickBooks Desktop software. However, you need a licensed version of QuickBooks Desktop to utilize its full functionality.
How do I know if QuickBooks Database Server Manager is installed correctly?
You can verify the installation by checking the QuickBooksDBXX service in the Services window. If it’s running and set to automatic, QBDSM is installed correctly. Additionally, ensure you can access QuickBooks in multi-user mode without errors.
Can I use QuickBooks Database Server Manager on a Mac?
No, QBDSM is designed for Windows operating systems. For QuickBooks Desktop for Mac, you would need different multi-user configuration methods.
How do I uninstall QuickBooks Database Server Manager?
To uninstall QBDSM, go to “Control Panel” > “Programs and Features,” find QuickBooks Database Server Manager, and click “Uninstall.” Follow the prompts to remove it from your system.
How do I add a new company file to the QuickBooks Database Server Manager?
To add a new company file to QBDSM, open the tool, go to the “Scan Folders” tab, click “Add Folder,” and select the folder containing your new company file. Click “Scan” to start scanning and add the file.
What are .ND and .TLG files created by QuickBooks Database Server Manager?
The .ND file (Network Data file) is used to manage multi-user access and is automatically created by QBDSM when a company file is scanned. The .TLG file (Transaction Log file) keeps track of transactions in QuickBooks to ensure data integrity.
Conclusion
The QuickBooks Database Server Manager is an invaluable tool for businesses that need to manage QuickBooks in a multi-user environment. Proper installation and configuration of QBDSM ensure seamless collaboration, data security, and improved productivity. By understanding how to download, install, set up, and troubleshoot QBDSM, you can ensure that your QuickBooks company files are always accessible and secure.
Comments