Troubleshooting - Error = 80040437, The user you are trying to log in with is already logged in from another machine.

Problem Description:

Our company uses QuickBooks 2018 contractor edition, which allows only one user simultaneously.

Yesterday, I set up QODBC with an admin account. Our finance team leader always uses this account.

Therefore, the QODBC driver can't connect to QuickBooks today. It has 80040437. The user you try to log in with is already logged in from another machine.

The team leader accesses from her work machine, and QODBC is running on a QuickBooks Server machine.

Could you advise how we can solve this problem?

Solution:

Scenario: QuickBooks is running, and a QuickBooks user is logged in to QuickBooks Company File:

When you connect to QuickBooks using your Application through QODBC, at that time, QODBC will connect to QuickBooks using QuickBooks SDK & log in to QuickBooks with the "User," which is currently logged in to Company File. The user specified in the Integrated Application Preference is ignored.

Scenario: QuickBooks is not running, and you have configured QODBC to auto-login to QuickBooks:

When you connect to QuickBooks using your Application through QODBC at that time, QODBC will connect to QuickBooks using QuickBooks SDK & start QuickBooks in the background with & log in to QuickBooks with the "User" which you have selected in the Integrated Application Preference at the time of certificate acceptance in QuickBooks.

So when the same user has already login to QuickBooks Application & you try to connect to QuickBooks using your Application through QODBC with the same user, you will face the above issue.

You are trying to log in to QuickBooks Application using the same user from two locations (i.e., 1st from QuickBooks Application in the foreground & 2nd through QODBC in the background.) which is impossible.

You can ask the user (who is also associated with the QODBC Integrated application) to log off from QuickBooks.

OR

You can use another user account on the integrated application configuration.

Follow the steps below for using another user account on the integrated application configuration.

Change Integrated Application access user from QuickBooks UI via Edit Menu -> Preferences -> Integrated Applications -> Company Preferences Tab.

Switch to the Company Preferences tab, Select "FLEXquarters QODBC," and Click "Properties."

Integrated Application shows Access rights for the User.

You can change Access rights for the User by selecting another user account from the dropdown list & clicking "OK," and closing Integrated Application Preference & checking again.

If you are connecting for the first time, you will get the below option at the time of connection. You need to select the User Name at the time of certificate and accept the process by which you want to use it.

You need to accept the certificate for each Windows User & for each application you want to use with QODBC.