Article - CS442365
"Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed" during ThingWorx installation/upgrade with ODBC Driver 18 due to Microsoft SQL Server Certificate Validation
Modified: 07-Aug-2025
Applies To
- ThingWorx Platform 9.6 to 10.0
- Microsoft SQL Server
- Microsoft ODBC driver
Description
- Installation/upgrade of ThingWorx running on Microsoft SQL Server (mssql) fails when using Microsoft ODBC Driver 18
-
Error: Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]
-
Error: Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection
- Updated the database connection string in \ThingworxPlatform\platform-settings.json with ssl=required, but it still failed to connect
- Issues include parse failures, TLS handshake errors, and unexpected disconnects with Driver 18
- Installation/upgrade failures due to CINC errors
This is a printer-friendly version of Article 442365 and may be out of date. For the latest version click CS442365