Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Error 6189: "QuickBooks is Unable to Determine the Cause of the Error on the local file"

If you open a local company file, and the file and the database server are on the same computer, the following error appears.
Error 6189: "QuickBooks is unable to determine the cause of the error on the local file"
This error is usually related to file access permissions for the folder where the company file is saved. When you use the default location for QuickBooks Desktop company files, the folder permissions are handled by QuickBooks Desktop. When you use non-default locations, the folder permissions may not be adequate and this error may appear.
How to fix it
To resolve this issue, be sure the appropriate user has full permissions to the folder where the company file is saved. Which user requires full permission is determined by the mode in which QuickBooks Desktop is operating.
To determine which mode QuickBooks Desktop is in, press the F2 key when you're in QuickBooks Desktop. In the Product Information window that opens, look at the bottom of the window for "Hosting". An entry of "Off" means you're in non-hosting mode and an entry of either "local files only" or "local & remote files" means you're in hosting mode.
  • If you are working in non-hosting mode, the Windows user accessing the file requires full permissions.
  • If you are working in hosting mode, the QuickBooks data service user (QBDataServiceUser) requires full permission.
If your company file is not located in these default locations, follow the steps below to manually set the folder permissions.
Default Windows 7, 8, 8.1 and 10 location: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files
Important: In each instance below, replace QBDataServiceUserXX with the name that corresponds to your version of QuickBooks:
  • QuickBooks 2017 or Enterprise Solutions 17.0 QBDataService User27
  • QuickBooks 2016 or Enterprise Solutions 16.0 QBDataService User26
  • QuickBooks 2015 or Enterprise Solutions 15.0: QBDataServiceUser25
  • QuickBooks 2014 or Enterprise Solutions 14.0: QBDataServiceUser24
In Microsoft Windows Vista, 7, 8.1 and 10:
  1. Right-click the folder where your company file is located and choose Properties.
  2. Click the Sharing tab, and then click Advanced Settings.
  3. (For hosting mode only) Click Permissions, select the QBDataServiceUserXX and click Full Control.
    (For non-hosting mode only) Click Permissions, select the Windows user (usually your name) and click Full Control.
  4. Click OK twice, and then click Close.
KB ID# SLN42136
10/21/2016 6:08:37 AM
PPRDQSSWS404 9138 Pro 2017 ccd73a