QuickBooks error "Unable to open database the file is being used by another user" with Auto-Protect enabled

Products

• Endpoint Protection

Issue/Introduction

After installing Symantec Endpoint Protection on the server hosting the QuickBooks database, clients are seeing an error about the file being in use.


 

Unable to open database files on the server unless Auto-Protect is disabled.

Cause

The normal operation of this application conflicts with Auto-Protect scanning.

Resolution

1. Create a centralized exception policy for the server's client for the files indicated by the Intuit support website on this issue.

Intuit lists two directories for a default Quickbooks installation:

C:\Program Files\Intuit\QuickBooks [Version]

• (i.e. C:\Program Files\Intuit\QuickBooks 2008)

C:\Program Files\Intuit\QuickBooks Enterprise Solutions [Version]

• (i.e. C:\Program Files\Intuit\QuickBooks Enterprise Solutions 8.0)

Please confirm if you have installed to the default directory before applying a CE policies. If you installed to a custom directory, you must use the full path to the custom directory so that the exclusion is accurate.

For 32-bit machines, create an exception to exclude scanning of the following directories. Please note the content in brackets varies depending on the version of Quickbooks that you are using.

QBServerUtilityMgr.exe located in C:\Program Files\Common Files\Intuit\QuickBooks\

FileManagement.exe located in C:\Program Files\Intuit\QuickBooks [version or Enterprise Solutions version]

QBCFMonitorService.exe located in C:\Program Files\Common Files\Intuit\QuickBooks

QBDBMgr.exe located in C:\Program Files\Intuit\QuickBooks [version or Enterprise Solutions version]

QBDBMgrN.exe located in C:\Program Files\Intuit\QuickBooks [version or Enterprise Solutions version]

QBGDSPlugin.exe located in C:\Program Files\Intuit\QuickBooks [version or Enterprise Solutions version]

QBW32.exe located in C:\Program Files\Intuit\QuickBooks [version or Enterprise Solutions version]

QBUpdate.exe located in C:\Program Files\Common Files\Intuit\QuickBooks\QBUpdate

Please be sure to include a full path for your 64 bit machines \Program Files(x86)\ directory. Do not use a prefix variable.

Note: You will also need to allow the port being used by Quickbooks in your firewall policy.

• The default port being used in Quickbooks 2007 is 10172.
• The default port being used in Quickbooks 2008 is 10180

2. If the above solution does not work, Upgrade Quickbooks server to the current version.

Note: Intuit is aware of the issue.  Intuit has stated that the issue is resolved by creating the above detailed Centralized Exceptions and upgrading QuickBooks to the current version.

References
For more information, please refer to the Quickbooks support website for this issue.

Additional information and further troubleshooting steps for this issue can also be found in this Quickbooks support site article.