Set the value of this additional setting to 1 to add "Encrypt=Yes; TrustServerCertificate=Yes" entries to the ODBC connection string when connecting to the SQL Server in a Linux client machine that has MSSQL ODBC version 18 and above installed. By default 'Encrypt=No' will be used in the ODBC connection string.
Details
| Setting name: | TrustServerCertAndEncryption |
|---|---|
| Category: | MSSQLAgent |
| Created on: | Client |
| Type: | Boolean |
| Min value: | None |
| Max value: | None |
| Default value: | False |
| Supported values: | 0, 1 |
| Supported versions: | 11.38 to 11.38 |
| Requires restart: | No |