Skip to content
  • There are no suggestions because the search field is empty.

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).] SSL Security Error article answering?

This article helps Webgility Desktop users resolve the “[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).] SSL Security Error” that may occur when connecting to a SQL Server database. It explains the common causes of this error and provides step-by-step instructions to restore the connection, ensuring smooth syncing between Webgility Desktop and QuickBooks Desktop.

Error:

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security Error

 

Cause of the issue:

This issue typically occurs when Webgility Desktop is trying to connect to the database hosted on SQL Server. There can be multiple reasons for this error, some of which are mentioned below:

  • SQL Server Encryption Settings (The server is forcing encryption, but the client lacks an SSL certificate)

  • Firewall or Network Restrictions – (Security software or firewall might be blocking the TLS handshake)

  • Outdated SQL Server (Older SQL clients do not support the latest security protocols)

Steps to fix:

  • Check SQL Services Status

  • Activate SQL Protocols

  • Configure Firewall Settings

  • Create exceptions for Webgility Desktop, Scheduler, and SQL Server applications in the Windows firewall.

Follow the steps in this helpful article on SQL database connection issue

  • In case if the issue persists then download the latest version of the SQL Server (express edition) available and install it. Once done then try to restore the existing database and check again.

    Follow the steps in this helpful article on How to Manually Install SQL

Note: Make sure there are no pending updates for the Windows operating system.