Unable to Connect to QuickBooks Enterprise Server

Modified on Sun, 26 Jul at 2:32 AM

Overview

This error occurs when QQube cannot connect to the QuickBooks Enterprise Custom Reporting feature because the Custom Reporting user credentials or permissions are no longer valid.

Message You May See

Synchronization log message

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 10/15/2027 06:44:57 PM >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
SybaseSession_ExecuteNonQueryCommand
ExecuteNonQuery
Unable to connect to server 'QQube_CustomReportingServer': [Sybase][ODBC Driver][SQL Anywhere]
Invalid user ID or password
CREATE EXISTING TABLE "41646d696e"."crp_AccountQuery" AT 'QQube_CustomReportingServer. v_lst_account'
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

What the Error Means

QQube uses selected information from the QuickBooks Enterprise Custom Reporting feature to supplement data available through the Intuit Software Development Kit.

The error means that QQube can no longer authenticate with the Custom Reporting user configured for the affected QuickBooks company file.

Possible Causes

Possible Cause	Required Action
Custom Reporting user is missing	Recreate the required Custom Reporting user.
Password changed	Restore the original password or update the stored credentials in QQube.
Permissions changed	Restore the required permissions for the Custom Reporting user.
QuickBooks installation or file access problem	Repair QuickBooks, confirm Database Server Manager folder tracking, and correct company-file permissions.

Resolution

1. Recreate a Missing Custom Reporting User

Follow Create Connection Users to create the required Custom Reporting user and assign the correct permissions.

2. Correct a Changed Password

Change the Custom Reporting user password back to the password originally stored in QQube.

QuickBooks Custom Reporting user password settings

Or: Set a new password, then remove the company file from the QQube Configuration Tool and add the company file again during the same operation. This stores the new Custom Reporting credentials in QQube.

QQube Configuration Tool company-file connection settings

3. Restore the Required Permissions

Review the permissions assigned to the Custom Reporting user and restore the required access.

QuickBooks Custom Reporting user permissions

4. Repair QuickBooks or Company-File Access

QuickBooks-related connection problems may be caused by:

A corrupt QuickBooks installation or release update.
QuickBooks Database Server Manager not tracking the folder containing the company file.
Incorrect permissions on the QuickBooks company file or its folder.

Run the QuickBooks utility that repairs company-file and network problems. In a Multi-User implementation, run it on the server.

Review Fix company file and network issues with QuickBooks File Doctor.

QuickBooks Tool Hub company-file and network repair utility

Expected Result

QQube connects successfully to the QuickBooks Enterprise Custom Reporting feature, and the synchronization completes without the invalid user ID or password error.