Using Clarion 11 with MSSQL database driver for several years. Last week, a client updated MSSQL Studio to the latest version on a workstation. Since then, when they first sign in to our application, the SQL Server returns the following “certificate error:”
Connection failed:
SQL State: “08001”
SQL Server Error: -2146893019
[Microsoft][ODBC Driver 18 for SQL Server] SSL Provider: The certificate chain was issued by an authority that is not trusted.
[Microsoft][ODBC Driver 18 for SQL Server] Client unable to establish connection. For solutions related to encryption errors, see Connection encryption troubleshooting - ODBC Driver for SQL Server | Microsoft Learn
Interestingly, the client is able to proceed, and our application works fine. But it appears Microsoft SQL has started requiring certificates. We uninstalled the latest ODBC drivers on the workstation (rolling back to the previous drivers) and the certificate error went away.
Any suggestions? Is this something Clarion Development knows about?