Learn how to host your company files over a network with Database Server Manager in QuickBooks Desktop.
After you install the Database Server Manager, you need to scan your company files. Once you scan them, you can access your company files from other computers on your network. This lets you and users on your network work together in QuickBooks Desktop from multiple computers.
If you have questions about hosting, learn more about setting up networks for QuickBooks Desktop.
Step 1: Scan your folders
Before you can share your files, you need to scan the folders holding them. You only need to scan them once.
On your server computer (the one that hosts your company files), open the Windows Start menu.
Type “Database” into the search and open QuickBooks Database Server Manager.
Go to the Scan Folders tab. Important: If you're using Database Server Manager 2019, this process shares all of your folders. You may want to set your folder permissions so you only give access to specific users.
Select Browse. Then select the folders that hold your company files (QBW).
Select OK when you're finished. This shows the open window after you select Browse. Find the folders holding your company files.
When you’re ready, select Start Scan.
When the scan finishes, the folders appear in the “QuickBooks company files found” section. You can now access the company files in these folders from other computers on your network.
Step 2: Monitor your drives
After you scan folders, the drives that hold them show up in the Monitored Drives tab. Select the drive to monitor these folders. This way, you won't need to rescan the folders if you ever change or move the company files in them.
Go to the Monitored Drives tab.
Select the checkboxes for the hard drives that hold your company files. Note: Only add drives that you hold your company files. This image shows your available drives. These are the ones that hold your company files.
Now if you ever change or move company files on the drive, you won't need to rescan the folders.
Note: You can't monitor mapped drives.
Step 3: Manage Database Server Manager
There are other tabs in Database Server Manager that help keep everything running smoothly.
The System tab tells you where the Database Server Manager is installed on your computer.
The Database Server tab gives you the real-time status of the tool and who is connected to it.
Note: QuickBooks Desktop 2019 uses dynamic ports and specific port numbers for better performance. If Database Server Manager isn't running, you may need to change your firewall settings so it can run on your server.
Restart Database Server Manager
If you can't open the Database Server Manager or see an error, we may recommend restarting it on your server computer (the one that hosts your company files). To restart, follow the steps for your current set up.
If you installed QuickBooks Desktop and Database Server Manager:
Open QuickBooks Desktop on your server computer.
Go to the File menu. Then select Open or Restore Company.
Select Open a company file. Find and open your company file. Then select Next.
Select the Open file in multi-user mode checkbox, then select Open.
Log in to your company file.
Go to the File menu and select Close Company/Log off. This closes your company file on the server.
Open the Windows Start menu.
Type “Database” into the search and open QuickBooks Database Server Manager.
If everything works, you're good to go. If you still see an error message, follow the steps in the "If you only installed Database Server Manager."
If you only installed Database Server Manager:
Select the Windows Start menu.
Search for and open Control Panel.
Select and open Administrative Tools.
Select Services from the list.
Right-click the QuickBooksDBXX service and then select Restart. Note: XX is the year of your Database Server Manager. For example, the 2018 version is QuickBooksDB28.
If Database Server Manager doesn't restart, restart your server computer. Then follow these steps again.
If you still have problems, you can clean install QuickBooks Desktop or contact our support team. We can help repair your Database Server Manager.
Source: https://accountspremier.wordpress.com/2020/03/30/use-of-quickbooks-database-server-manager/
After you install the Database Server Manager, you need to scan your company files. Once you scan them, you can access your company files from other computers on your network. This lets you and users on your network work together in QuickBooks Desktop from multiple computers.
If you have questions about hosting, learn more about setting up networks for QuickBooks Desktop.
Step 1: Scan your folders
Before you can share your files, you need to scan the folders holding them. You only need to scan them once.
On your server computer (the one that hosts your company files), open the Windows Start menu.
Type “Database” into the search and open QuickBooks Database Server Manager.
Go to the Scan Folders tab. Important: If you're using Database Server Manager 2019, this process shares all of your folders. You may want to set your folder permissions so you only give access to specific users.
Select Browse. Then select the folders that hold your company files (QBW).
Select OK when you're finished. This shows the open window after you select Browse. Find the folders holding your company files.
When you’re ready, select Start Scan.
When the scan finishes, the folders appear in the “QuickBooks company files found” section. You can now access the company files in these folders from other computers on your network.
Step 2: Monitor your drives
After you scan folders, the drives that hold them show up in the Monitored Drives tab. Select the drive to monitor these folders. This way, you won't need to rescan the folders if you ever change or move the company files in them.
Go to the Monitored Drives tab.
Select the checkboxes for the hard drives that hold your company files. Note: Only add drives that you hold your company files. This image shows your available drives. These are the ones that hold your company files.
Now if you ever change or move company files on the drive, you won't need to rescan the folders.
Note: You can't monitor mapped drives.
Step 3: Manage Database Server Manager
There are other tabs in Database Server Manager that help keep everything running smoothly.
The System tab tells you where the Database Server Manager is installed on your computer.
The Database Server tab gives you the real-time status of the tool and who is connected to it.
Note: QuickBooks Desktop 2019 uses dynamic ports and specific port numbers for better performance. If Database Server Manager isn't running, you may need to change your firewall settings so it can run on your server.
Restart Database Server Manager
If you can't open the Database Server Manager or see an error, we may recommend restarting it on your server computer (the one that hosts your company files). To restart, follow the steps for your current set up.
If you installed QuickBooks Desktop and Database Server Manager:
Open QuickBooks Desktop on your server computer.
Go to the File menu. Then select Open or Restore Company.
Select Open a company file. Find and open your company file. Then select Next.
Select the Open file in multi-user mode checkbox, then select Open.
Log in to your company file.
Go to the File menu and select Close Company/Log off. This closes your company file on the server.
Open the Windows Start menu.
Type “Database” into the search and open QuickBooks Database Server Manager.
If everything works, you're good to go. If you still see an error message, follow the steps in the "If you only installed Database Server Manager."
If you only installed Database Server Manager:
Select the Windows Start menu.
Search for and open Control Panel.
Select and open Administrative Tools.
Select Services from the list.
Right-click the QuickBooksDBXX service and then select Restart. Note: XX is the year of your Database Server Manager. For example, the 2018 version is QuickBooksDB28.
If Database Server Manager doesn't restart, restart your server computer. Then follow these steps again.
If you still have problems, you can clean install QuickBooks Desktop or contact our support team. We can help repair your Database Server Manager.
Source: https://accountspremier.wordpress.com/2020/03/30/use-of-quickbooks-database-server-manager/
Comments
Post a Comment