Set up and Install a Multi-user Network for QuickBooks Desktop

,

Multi-user Network for QuickBooks Desktop

If you want multiple users to have access to the same company file, then you need to set up and install a multi-user Network for QuickBooks Desktop. There are three components to this setup: Windows, Server, and QuickBooks Desktop. In this article, you’ll find all the required steps for setting up each of these components to configure a multi-user network.

Configure QuickBooks Desktop for Multi-User Network

The server computer hosts the company file, and all the other workstations access the data from the server computer. This setup is extremely simple to set up if you follow the instructions with clinical precision.

To configure QuickBooks Desktop for a multi-user network, follow the steps provided below:

  • Download and Install QuickBooks Desktop on the server.
  • When installing, select Custom and Network Install.
  • Choose I’ll be using QuickBooks Desktop on this computer, And I’ll be storing… Installing QuickBooks desktop on the server provides you with the flexibility to make changes to the data from the server computer. If you don’t want this, you can select I will not be using QuickBooks desktop on this computer…
  • Go through the rest of the installation process on the basis of on-screen instructions.
  • Click on Finish.

Store the company file on the local hard drive. This can help you in avoiding various network and company file errors that are difficult to troubleshoot.

You can also keep your files on a mapped network drive by following the steps provided below:

  1. From the Start menu, select This PC.
  2. Go to the Computer tab, and select Map a Network Drive.
  3. Choose a drive letter that isn’t associated with any existing drive. Click on Browse.
  4. Choose the network location in which your company file is stored.
  5. Click on Ok, then Finish.
  6. Launch QuickBooks and access the company file from the mapped drive.

Mapping can fairly simplify the way in which the company file is shared with different workstations. All the workstations can simply share the company file from the shared storage.

Configure Correct Folder Permissions

Correct folder permission needs to be set in order to enable access of company files from different workstations. Note that the alternate hosting mode can create issues with multi-user mode.

To set up folder permissions, follow the steps provided below:

  1. From the start menu, select File Explorer.
  2. Right-click on the Folder which contains the company file.
  3. Go to Properties and select the Sharing tab.
  4. Click on Share Add.
  5. Choose QBDataServiceUserXX, where XX corresponds with the version of your QuickBooks.
  6. Select Full Control as the permission level for all users.
  7. Click on Share.

Now that you’ve set the proper share settings, you can move on to setting up the rest of the infrastructure to enable multi-user mode in QuickBooks.

Configure the Database Server Manager for Multi-User Network

The database server manager manages the company files which are shared over a network. By monitoring the multi-user network, it facilitates users to easily access and edit the company file.

To configure the QuickBooks Database Manager, follow the steps provided below:

  1. In the Start menu, type in ‘Services’. Hit Enter.
  2. Open QuickBooksDBXX, where XX is the version of your QuickBooks.
  3. From the General tab, check the status of the service. If the service status is Started or Running, then select Stop.
  4. Click on the Startup type drop-down menu. Choose Automatic.
  5. From the Logon tab, click on the Local System account option.
  6. Now, From the Recovery tab, choose to Restart the Service from the following menus: First Failure, Second Failure, Subsequent Failure
  7. From the General tab, click on Start.

Once you click on start, the database server manager will launch again with the proper configurations. At this point, you can also set firewall settings to provide QuickBooks access to certain blocked ports.

Configure User Rights

The user through which you access the company file on the server must have administrative privileges. To give admin rights to windows users, follow the steps provided below:

  • Go to the start menu.
  • Click on Settings.
  • Select Accounts.
  • Click on Family & Other users.
  • Select Change Account Type.
  • Select Administrator under Account Type.
  • Hit Ok.

Now that the user account has administrative privileges, it can be used for making changes to data in any folder on the system. You can also give admin access to QuickBooks Programs by following the steps provided below:

  1. Close all Programs.
  2. From the Start menu, select Control Panel.
  3. Select User Accounts.
  4. Find the user with the name QBDataServiceUserXX, where XX corresponds to your version of QuickBooks.
  5. Select Administrator from Change the account type menu.
  6. Click on Change Account Type.
  7. Hit Apply.
  8. Repeat steps to give admin status to all versions of the database server manager.

Note: It is better to get in touch with a qualified Microsoft IT Professional if the server is set up as a domain controller.

Scan Folders with QuickBooks Database Server Manager

The database server manager has to scan the folders for available company files. Once the files complete scanning, they can be accessed through the multi-user mode. To scan your folders, follow the steps provided below:

  • In the Start Menu, type in Database.
  • Open QuickBooks Database Server Manager.
  • From the Scan Folders tab, select Browse.
  • Select all the folders which contain the company files.
  • Click on Ok.

Switch on Hosting

After successfully setting up everything, you can turn on hosting to enable multi-user access in QuickBooks. Note that the server should be the only system that has the multi-user access turned on. Workstations shouldn’t have this setting enabled.

To enable hosting on the server, follow the steps provided below:

  • Launch QuickBooks Desktop on the server.
  • Go to the File Menu.
  • Select Utilities.
  • Choose Host Multi-User Access.
  • To confirm, click on Yes.

Now, the multi-user mode is configured and enabled. Multiple users can work on the same company file at the same time. Any conflicts in the data can be easily resolved later on.

To know more, get in touch with our users at Live Chat.

FAQs

The installation files for the database server manager are included in the QuickBooks Desktop setup. If you choose to perform a Custom or Network install, the database server manager will be automatically installed on your system.
Yes. In QuickBooks, you have the option to limit the level of access a certain user has to the accounting data. It is highly recommended that you set this up for better security.

Post Written by

Steve Hale is a Content expert and Executive Editor with over 15 years of experience who writes original blogs on Bookkeeping. Hale writes optimized content for a range of clients about SEO, Bookkeeping, Quickbooks & Accounting. He was formerly the managing editor who used to oversee all aspects of the publication.

Leave a Comment

Disclaimer: We have experienced CPAs providing the quality solutions of QuickBooks for many years. Content available on our website is solely our property, and for any feedback contact our team via LIVE CHAT or Contact form. We are not associated with any other company like Intuit and work with our own T&C.

Enquire Here Chat Now