Knowledgebase
[QODBC-Desktop] Troubleshooting: Begin Session Failed. Error = 8004041d, 80040418, 8004041a, 80040430
Posted by brad waddell on 12 March 2009 05:21 PM

Troubleshooting: Begin Session Failed. Error = 8004041d, 80040418, 8004041a, 80040430

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

 

Problem Description:

I am receiving the error: “Recent changes to your configuration require you (the QuickBooks Administrator) to go into the Integrated Applications preferences and re-authorize your integrated application to log in automatically.” Immediately when starting the QODBC program.

Solutions:

Application integration authorization can only be granted by the QuickBooks user "Admin". A QuickBooks user (other than admin) with full access cannot grant permission.

Application integration authorization is required once per application for each Windows user. - http://qodbc.com/links/2785

Solution 1:

 

Please start QuickBooks, Log in to your QuickBooks company file as QuickBooks user "Admin"

 

Try connecting your application.

Accept the Integrated Application Certificate / Data Access Certificate on QuickBooks (if prompted).
After the Certificate is accepted, please close your application and log off from your QuickBooks company file.

 

Perform a test with your application.

Note: If you are using multiple applications with QODBC, you need to perform the above steps for all the applications. 

 

 

Solution 2:

Please start QuickBooks application, log in to your company file as QuickBooks user "Admin".

Switch to single-user mode.

Navigate to "Edit" Menu -> "Preferences"  -> "Integrated Applications" -> "Company Preferences" Tab.

Please make sure ALL the applications with the name "FLEXquarters QODBC" have the "Allow Access" option CHECKED/TICKED. If it is unchecked, please check it & apply changes by clicking the "OK" button.

Keep QuickBooks running and in single user mode, try to connect with your application.

If you are still facing the issue, please remove all the integrated applications in QuickBooks via QuickBooks -> Edit Menu -> Preferences -> Integrated Applications -> Company Preference Tab

How to remove QODBC Related Certificates from Integrated Application under QuickBooks

After removing all the "FLEXquarters QODBC"  integrated applications, please close the Integrated applications window.

Test the connection using QODBC Support Wizard and VB Demo

 

Please Note: If you are unable to connect to QuickBooks Data when a non-admin user is logged in to QuickBooks. You need to change the password of the non-admin QuickBooks user. For more information, please refer to Password security for QuickBooks Desktop.

Problem Description:

I have installed the latest version on a PC running Windows 2008 R2 and Reckon Enterprise 2014. I got the following message when I tried to test the link:

"QB Begin Session Failed. Error = 80040430, This application is unable to log into the Reckon Accounts company data file automatically. The Reckon Accounts administrator must grant permission for automatic login through the Integrated Application preferences. If such permission was already granted, the administrator must revoke permission, then grant the permission again"

 

Error.png 

Solutions:

I want to inform you that the above error says that you have not accepted the QuickBooks certificate. Please keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode and try to connect using your application. It should pop-up Data Access Certificate on QuickBooks, Please accept the integrated application certificate and try again.

Please create new MS Access database & keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode and try to connect, it should pop-up Data Access Certificate on QuickBooks, Please accept the certificate. 

I want to inform you that the QuickBooks issue Certificate is for each application. You might have accepted the certificate for application A, but application B would not have access. 

Notes for QB 2006 and before Users

For those who use QuickBooks 2006 and the previous version, please see: After upgrading to QuickBooks 2006, QODBC "auto-login" unattended mode no longer works? For more details on troubleshooting auto-login mode connections.

This is a known problem that exists in the QuickBooks qbXML SDK from Intuit, caused by QuickBooks when upgrading an existing QuickBooks company file that had previously worked with QODBC to the new 2006 USA format (used by QuickBooks 2006 and 2007) or even adding new user accounts to QuickBooks. The problem still exists with QuickBooks 2007.

This issue is an Intuit SDK issue, not QODBC. Intuit required us to change unattended mode access for QuickBooks 2005 and 2006, which we did from QODBC v6.00.00.150 onwards. Unfortunately, all 2005 company files that have been accessed previously by QODBC have this problem when the company file is converted by QuickBooks to the new 2006 or 2007 Anywhere Sybase backend format. The Intuit conversion corrupts the internal integrated applications settings, and you need to do the 17 step procedure workaround.

The staff at IntuitQBES (QuickBooks Enterprise Solutions) would like me to pass the following message to you:

Using the R5 (or later) release for QuickBooks Enterprise Solutions Version 8, developers can now use their QODBC applications with QuickBooks closed.

Download the R5 (or later)update here:

http://support.quickbooks.intuit.com/Support/ProductUpdates.aspx

Remember that when using this feature, you have to use 'Locate a company file' or a QODBC connection string with "DFQ=C:\Program Files\QODBC Driver for QuickBooks\sample04.qbw" rather than 'Use the company file that's now open in QuickBooks'.

Note: R5(or later) for QuickBooks Enterprise 8 (2008) has the Intuit bug fix, not R11(or later) for QuickBooks Enterprise 7 (2007) !!!!

(99 vote(s))
Helpful
Not helpful

Comments (1)
Eric
20 September 2012 03:44 PM
Attn: QuickBooks Development:I own a construction compnay that does subcontract work for other construction companies in addition to being the prime contractor on many of our own projects. Several times I have brought to the attention of Intuit (through customer support) a problem with the way certain data is displayed and/or printed on various forms. Situation -My customer is “Smith Construction Co.”Smith Construction builds spec houses as well as custom houses for many different clients.Smith Construction needs pricing from me on several different phases of spec house being built on Lot 101. These may include Cabinets, Flooring, Tile, Carpet, Swimming Pool, etc.In QuickBooks, The Customer Name is entered as “Smith Construction”A Job under “Smith Construction” is entered as “Lot 101”Since Smith Construction is having several phases of the house on Lot 10 quoted by my compnay, each phase is entered as a sub job under the job “Lot 101” (Smith Construction:Lot 101:Cabinets). By doing this, I can track the profit or loss of each phase of the Lot 101 project being built by Smith Construction. Everything mentioned so far works and achieves my need for tracking the profit and loss as required.Here lies a problem that needs to be addressed by the QuickBooks development team.On any estimate or an invoice I send to Smith Construction, only the last portion of the job in the “Project/Job” field is displayed on that form. “Smith Construction:Lot 101:Cabinets” is displayed and printed only as “Cabinets” on an estimate or invoice. What I would like to be displayed is “Lot 101:Cabinets” so that my customer (Smith Construction) can identify which house this cabinet installation belongs to when looking at an estimate or invoice.Everything prints correctly on statements so I have to think this is an easy fix.Please let me know if this is something that can be added in future updates toQuickBooks.Sincerely,Kyle BowserTymeless FlooringQuickBooks Enterprise Solutions 11.00 30 user
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).