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.
If the problem persists, contact Webgility Support for further assistance.