Table of Contents
A QuickBooks Error 6175 could appear if you are a user having problems accessing your company file on the local server. Because of this coding, you might not open or use the file as intended. It can cause an error if QuickBooks cannot read the database services or the database server is unavailable. You can find a step-by-step tutorial on how to fix QuickBooks error code 6175 in this post.
Solution 1: Review your hosting settings
Step 1: Verify if the settings are compatible with the server system
There is a chance that one or more of your workstations have been configured as QuickBooks servers. The workstations are capable of multi-user operation. It is recommended that the mode be hosted solely on the server, the computer responsible for hosting your organization’s files.
Ensure that the Host Multi-User Access option is disabled on all workstations, or networked computers that do not host your organization’s files.
Note: Perform these steps before opening a company file.
- Launch QuickBooks on all workstations experiencing the issue, if you see H101, H303, or H505.
- Navigate to the File menu and position your cursor over the ‘Utilities’ option.
- It is recommended that you refrain from selecting the ‘Stop Host Multi-User Access’ option. Proceed to the next workstation.
- If the option to Stop Hosting Multi-User Access is available, select it.
- Ensure to perform these steps on all workstations that display Error -6175,0.
Step 2: Check your server settings
Follow the steps depending on your setup.
After you verify the hosting settings on all your workstations, go on to the server computer and reset the hosting settings to the default.
- Launch QuickBooks on your server computer.
- Navigate to the File menu and position your cursor over the Utilities option.
- If the option of host multi-user access is available, please choose it. Proceed with repeating this process and selecting the option to Stop Hosting Multi-User Access. This action resets the multi-user mode.
- Repeat the process once again and opt for the Host Multi-User Access option.
If you simply have Database Server Manager installed on your server PC, you do not have the complete version of QuickBooks Desktop.
Adhere to the steps given below
Step 3 : Scan your folders
You should look for the folders containing your files before you decide to share them. You may scan them once and be done with it.
- To access your company files, kindly navigate to the Windows Start menu on your server computer.
- To access QuickBooks Database Server Manager, please search for “Database” and open it.
- Navigate to the Scan Folders tab.
- Click on the “Browse” option. Choose the folders that contain your company files (QBW).
- Click on “OK” as now the task is done.
- Start the scanning process by clicking on the “Start Scan” option.
Upon completion of the scanning process, it will display the folders in the section designated “QuickBooks Company Files Found”. The folders containing the company files are now accessible from other computers within the network.
Step 4: Monitor your drives
After scanning folders, the drives that contain them appear in the Monitored Drives tab. choose the drive that you wish to monitor for these folders. Implementing this approach eliminates the need for re-scanning the folders in the event of any changes or relocation of the company files.
- Navigate to the Monitored Drives tab.
- Check the boxes next to the drives that contain your Company files. Only add drives that contain company files.
Note: You can’t monitor mapped drives.
Recommended to read : Why QuickBooks Cannot Communicate With The Company File
Step 5: Manage Database Server Manager
The Database Server Manager features additional tabs that ensure smooth functioning.
- The System tab provides information regarding the location of the Database Server Manager installed on your device.
- The Database Server tab provides up-to-date information on the tool’s status and the individuals currently connected to it.
Restart Database Server Manager
If you are unable to launch Database Server Manager or encounter an error, we recommend restarting it on your server computer (the one that hosts your Company files). Follow the procedures for your existing configuration to restart.
If you installed a Database Server Manager and QuickBooks Desktop:
- In your server PC, launch QuickBooks Desktop.
- To access your company’s data, please navigate to the “File” tab and select “Open or Restore Company”.
- Choose the option to “Open a Company File.” Locate and access your organization’s file. Now, proceed by selecting the “Next” option.
- To enable multi-user mode, kindly check the “Open file in multi-user mode” option and select the “Open” button.
- Log in to your company file.
- To log off or close the company, kindly navigate to the “File” tab, and select “Close Company/Log off”. This action will effectively end the connection between your company file and the server.
- Open the Windows Start menu.
- Search for “Database” and launch QuickBooks Database Server Manager.
If all functions properly, you are ready to go. If you continue to see an error message, follow the instructions in “If you only installed Database Server Manager.”
If you have only a Database Server Manager installed:
- Click on the Windows Start menu.
- locate and access the Control Panel.
- Access the Administrative Tools and proceed with opening them.
- Choose the Services from the provided list.
- To restart the QuickBooksDBXX service, kindly right-click on it and select the Restart option. Please be advised that XX refers to the specific year of your Database Server Manager. The latest iteration of the software is identified as QuickBooksDB31, released in 2021.
Restart your server PC if the Database Server Manager does not restart. Then repeat these actions.
If you still see QB payroll error -6175,0, move on to Solution 2.
Solution 2: Use QuickBooks File Doctor
A utility called QuickBooks File Doctor updates your system files. Use the instructions to download and launch the File Doctor.
Continue to Solution 3 if QB Error -6175,0 is still shown.
Solution 3: Check your hosting settings
- Take a look at your Windows User settings. Add QBDataServiceUser as a user with admin access if you have not already.
- Verify the firewall’s settings. Make that your firewall permits QBW32.exe, QBUpdate.exe, QBDBMgr.exe, and QBDBMgrN.exe access.
If you are looking for a prompt fixation of QuickBooks Error 6175,
You may read also : How to fix Intuit Data Protect Has Stopped Working Error