Knowledgebase
[QODBC-Desktop] Troubleshooting - Changes to the Integrated Application Authentication for QuickBooks
Posted by Jack - QODBC Support on 21 June 2016 03:21 PM

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).

Problem Description:

Get the following errors from QODBC driver:

ERROR [00000] [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"

 

Step.png

 

Error.png

Solution:


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.

 

(3 vote(s))
Helpful
Not helpful

Comments (2)
Sandip Laxman Dahihande
09 February 2017 06:07 AM
I have tried above steps but still QuickBooks Enterprise Edition 2017 asked for Login into QuickBooks again and again. Please help
Jack
09 February 2017 06:44 AM
Hi Sandip,

Please make sure that you have accepted the certificate for each Windows Users who is accessing QuickBooks Data using QODBC.

If Windows User/Work Station changed, then you need to reauthorize application.

If QuickBooks is asking certificate for same application for same Windows user which you accept earlier, then I kindly suggest refer below mentioned link & follow steps:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2406/60/connection-lost-between-qodbc-and-quickbooks-quickbooks-asking-for-password

If you are still facing the issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).