Troubleshooting - Changes to the Integrated Application Authentication for QuickBooks
Intuit is reinforcing existing security features that help protect QuickBooks customers’ sensitive information.
Refer : Intuit's News : Changes to the Integrated Application Authentication for QuickBooks Desktop users
As a result of this effort, Intuit is delivering an update that impacts third-party applications that connect to QuickBooks using the QuickBooks SDK.
A new file specific to a Windows user in a given machine is created on user login that provides access to an SDK app in QuickBooks.
The implementation of this update will require customers to re-enter their login-in credentials & authorize application(i.e QODBC) in QuickBooks.
For Example, You have 4 windows users. All of those 4 windows users uses QODBC via Microsoft Excel,Access, Crystal or any other applications. You will need to authorize EACH applications from all the 4 Windows user. That means you will need to login to the 1st windows user, authorize all the applications that will be using QODBC, then login to 2nd Windows user and authorize all the applications that will be using QODBC. This is because Intuit's LGB file which was common earlier is now changed to new a method and integration information will be stored for each Windows user separately.
Above is applicable for a Single machine, Terminal Services(Remote desktop connection) or Workstation(s).
Get the following errors from QODBC driver:
ERROR  [QODBC] QB Begin Session Failed. Error = 8004041d,80040418 This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for automatic login through the Integrated Application preferences.
Test connection to Quick Books - FAILED: "[QODBC] QB Begin Session Failed. Error = 8004041a. This application does not have permission to access this QuickBooks company data file. The QuickBooks administrator can grant access permission through the Integrated Application preferences"
You need to follow below steps to reauthorize QODBC for QuickBooks.
1. Login to Windows, Open QuickBooks & login to company file as Admin.
2. Switch Company File to Single User Mode.
3. Connect using your application. It should pop-up Data Access Certificate on QuickBooks, Please accept the Certificate. QuickBooks issue Certificate is for each application, So you need to accept the certificate for all application which you are using with QuickBooks.
4. You need to log in for each Windows Users who is accessing QuickBooks Data using QODBC.
If Windows User/Work Station changed, then you need to reauthorize application using above steps.
If the company file has Personally Identifiable Information (PII) in QuickBooks, users will be required to login with a password; the SDK app will only be allowed to connect once the login has been completed for that user.
When logging in, customers will be instructed to set up a strong password. Customers should use unique letters and numbers in a password, not basic words that can easily be found online or in the dictionary.