Troubleshooting: QuickBooks Reports "The Certificate is Invalid"

Problem Description:

When first using the application to access QuickBooks via QODBC, a will pop up a window to ask the user to give the certificate to this application.

But now facing a problem that QuickBooks reports the certificate is not valid:

When trying to test the connection, QODBC reports this error:

Solution:

First, please ensure you are connected to the Internet on the machine.

Then please check the property of your fqqb32.dll file. You can find the fqqb32.dll file at:

C:\Windows\SysWOW64 (64-bit system) C:\Windows\System32 (32-bit system)

Right-click on that file, select the "Properties" option

In the "property" window, go to the "Digital Signature" tab, and check if the certificate of "FLEXquarters.com Limited" is valid by clicking the "Detail" button.

If it is not showing up valid, please follow the steps below to install the certificate:

1) Make sure the Internet is available on that machine and it can reach VeriSign's website

2) On the Properties of the file fqqb32.dll, click "Digital Signature" to view the signature. Click on "View Certificate" and "Install Certificate."

3) Restart the machine.

4) Test the connection again to see if the problem is fixed.

If the above solution does not work, then you need to manually install the certificate by using below link:

http://www.symantec.com/business/support//index?page=content&pmv=print&impressions=&viewlocale=&id=TECH218029

Note: Windows 7 doesn't support SHA256 signatures by default. You need to apply windows up

Refer:

Microsoft security advisory: Availability of SHA-2 code signing support for Windows 7 and Windows Server 2008 R2: March 10, 2015

Microsoft Security Advisory 2949927

You cannot run an application that is signed with an SHA-256 certificate on a computer that is running Windows Vista SP2 or Windows Server 2008 SP2

SHA2 and Windows