Cannot connect to SQL Server using ODBC Driver 18: SSL certificate chain is not trusted

[afra-pro]

Environment

• TMS Data Modeler: Version 4
• SQL Server: 2019
• Operating System: Windows 11
• ODBC Driver: Microsoft ODBC Driver 18 for SQL Server

Problem

When trying to import the database schema from SQL Server, the connection fails with the following error:

[FireDAC][Phys][ODBC][Microsoft][ODBC Driver 18 for SQL Server]
SSL Provider: The certificate chain was issued by an authority that is not trusted.

Steps to Reproduce

1. Open Data Dictionary Import.
2. Select ODBC Driver 18 for SQL Server.
3. Enter a valid SQL Server instance, username, and password.
4. Click Test Connection or Import.

Expected Behavior

The application should connect successfully, or provide an option to configure SSL settings such as:

• TrustServerCertificate=True
• Encrypt=False

These options are currently not available in the connection dialog.

Additional Information

• The same SQL Server instance can be accessed successfully from SQL Server Management Studio by enabling Trust Server Certificate.
• The problem appears to be related to the default encryption behavior introduced in Microsoft ODBC Driver 18.
• Since TMS Data Modeler does not expose connection string or SSL options, there is currently no workaround within the application.

Could support for TrustServerCertificate=True (or an advanced connection string option) be added to the SQL Server connection dialog?