Description of Error:
When trying to connect the ESC Accounting Server to QuickBooks, the accounting server returns the error:
Error beginning Quickbooks session. If the Quickbooks company data file is not open, a call to the "BeginSession" Method must include the name of the data file.
Cause of Error:
According to Intuit, the error may occur if the QuickBooks company data file is not open or there is a communication problem between the third party application and the QuickBooks database.
As the possible causes of this problem can vary, please try the solutions indicated below in order until the problem is solved:
- Apply all Intuit updates to the computer that runs the ESC Accounting Server and retest.
- Within QuickBooks, login as the Admin user and switch to single-user mode. Go to Edit → Preferences → Integrated Applications → Company tab and delete the ESC certificate reference there. Close all of those screens but remain in QuickBooks as the admin in single user mode and try to reconnect the ESC Accounting Server. A new QuickBooks Integration Certificate will appear: allow it to 'always' connect, select the ESC user as the login user, and put a check in the "Allow access to personal data..." option. Click Continue and then Done.
- In QuickBooks, login as the Admin user and switch to single-user mode. Click on File → Utilities → Rebuild Data. Intuit recommends performing the rebuild data process three times in a row for the best possible results.
- If the QuickBooks data file resides locally on the ESC Accounting Server computer, ensure that QuickBooks is logging into it's database file locally and not through a mapped drive. Mapped drives are only required on workstations and using a mapped drive on the ESC Accounting Server computer can cause issues.
- Ensure that UAC (User Access Control) is enabled within Windows Vista or higher operating systems. At present, QuickBooks requires that this must be enabled for it to work properly.
- The location of the QuickBooks database may be in a directory that is not being shared properly and may not have full read/write permissions available. This can be tested out by moving the QBW file to a more standardized location and retesting the access.
- If the problem persists, perform a full uninstall of the QuickBooks application as well as the ESC Accounting Software. Reinstall both programs, reapply all Intuit updates and retest.
- Move the ESC Accounting Server to a new machine and test the connectivity. If it works from a different machine, then the problem is confirmed to be with the original computer and is not related to ESC, the ESC Accounting Server, the integration or the QuickBooks database file.