Knowledgebase
[QODBC-Desktop] Troubleshooting - QuickBooks Displays a Revoked Certificate Warning
Posted by Jack - QODBC Support on 04 May 2016 06:49 AM

Troubleshooting - QuickBooks Displays a Revoked Certificate Warning

Problem Description:

I am trying to connect to QuickBooks using QODBC. At a time of connection, QuickBooks Displays a Revoked Certificate Warning.

 

 

 

Solution:

Please update your QODBC to the latest QODBC version and test again.

Please click here to get the latest QODBC version.

If you are still getting the same error after updating the version, please check the digital signature of the application you are using, like crystal report, excel.

For Example:

If you are using MS Excel and getting errors, please check the digital signature in MS Excel.

Open the task manager, right-click on EXCEL.EXE, and click on Open File Location.



You will be navigated to the application location. In this example, we will navigate to Excel exe location.



Once we reach the exe location, we must right-click on exe and click on Property. We will right-click on EXCEL>EXE in this example and click on Property.



Navigate to the Digital Signatures tab & click on Details.



Click on View Certificate to see certificate validity details.



You can see the certificate validity details.



If your application Digital Certificate validity is expired, you need to get in touch with the Application Vendor to resolve the issue.

 

 

Windows Enforcement of Authenticode Code Signing and Timestamping

On Windows 7 platforms and above, the following are new guidelines from Microsoft:

  • Microsoft will no longer allow new SHA-1 code signing certificates to be used for signing files on Windows 7 and above starting Jan. 1, 2016.
  • Files signed previously with an SHA-1 certificate will continue to work on Windows 7 and above for an additional year as long as they were time-stamped before January 1, 2016.
  • Windows 7 and Server 2008 R2 will require a hotfix for SHA-256 support.
  • Starting on Jan. 1, 2017, all SHA-1 signed files would be blocked on Windows 7 and above, regardless of when they were time-stamped.



On Vista and Server 2008 platforms:

  • Microsoft will execute end-of-life support for Vista on April 2017 and Server 2008 on January 2020.
  • SHA-1 certificates will be supported through the end-of-life for these operating systems.
  • There will be limited support for SHA-256 on these platforms, requiring a patch and only allowing downloads or installations of SHA-256 signed content.



Microsoft TechNet:
Windows Enforcement of Authenticode Code Signing and Timestamping

On Vista and Server 2008 platforms:
Microsoft Authenticode - Dual Code Signing Instructions with SHA1 & SHA256 hashing Algorithm


For more details, refer:
Microsoft Windows SHA-1 & SHA-2 Code Signing Hash Algorithm Support
SSL News
SHA-1 Hash Algorithm Migration for SSL & Code Signing Certificates
SHA-1 Deprecation, On to SHA-2

 

Also, refer to the following:

Revoked Certificate Errors With QuickBooks Desktop Apps

(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).