Supports Strict encryption for SQL Server

The "Strict" encryption type is added to support TDS 8.0 in SQL Server 2022. For more information about TDS 8.0 and Strict encryption, refer to https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8?view=sql-se rver-ver16.

To support Strict encryption in the PowerServer project, you can select the Strict encryption when configuring the SQL Server database connection in the PowerBuilder IDE (PowerServer project painter > Database page > Basic tab > More button > Advanced dialog).


Or specify "encrypt=Strict" in the Applications.json file in the compiled Web API > AppConfig folder (or in the solution > UserExtensions project > AppConfig folder).

{
  "Applications": {
  ......
  },
  "Connections": {
    "Default": {
      "sales": {
        "ConnectionType": "SqlServer",
        ......
        "SecurityOptions": "encrypt=Strict",
        ......
      }
    }
  }
}