We’ve received a rash of support issues of late regarding failed QuickBooks connections. We thought we’d pass along this bit of information from Intuit regarding it in hopes it might mitigate the fallout. If you continue to experience issues, please leave a message on our forums.
The latest patches to QB 2015 and 2016 have implemented changes that cause OpenSync to fail when trying to connect to company files that are not currently open in QuickBooks. The error you will receive is: “Failed: This application is unable to log into this QuickBooks company data file automatically. The QuickBooks administrator must grant permission for an automatic login through the Integrated Application preferences. If such permission was already granted, the administrator must revoke permission, save preferences, then grant the permission again.: -2147220432”
The reason for this is that the application authorization settings were previously stored in a folder common to all Windows users. These updates moved the authorization information into a folder specific to the currently logged in Windows user. Therefore, to reauthorize the application you must follow these steps:
For each Windows user that will be running OpenSync, you must log into Windows as that user. Then open the company file in QB and login as the admin user. Switch to single user mode and remove the authorization for OpenSync. Next, reauthorize OpenSync with QB by adding the company file in OpenSync (You will receive a notification from OpenSync that the company already exists). Once you have completed this for all users the automatic connection should function properly.
This only applies to the computer running OpenSync. Any user that logs into that computer to run OpenSync must go through the reauthorization process. In addition, if either the OpenSync scheduling service (OSRunner.exe) or the OSRun command line utility (OSRun.exe) are configured to be run by the Windows scheduler then the Windows user they are configured to run under must login to the machine interactively and go through the authorization process detailed above.
In addition, these updates require that if you are trying to access sensitive information (credit cards, SSN, etc.) the QB user OpenSync is configured to connect to QB as must have a complex password. Intuit’s description of a complex password is: It should use unique letters and numbers in a password, not basic words that can easily be found online or in the dictionary.