NEW6.00.00 · Released 17 April 2025
High Importance
NEWfinPOWER Connect
Released in
6.00.00
17 April 2025
  1. Opened10 Oct 2024
  2. Closed14 Oct 2024
  3. Released17 Apr
Article 22294 Job J034464

SQL Server Databases; new option to set "Encrypt" connection string property

A new option has been added for SQL Server and Azure SQL databases to set Encryption options.

When opening a database, for example, you may specific the follow Encryption options under a new heading "Connection Security":

  • <blank>
    • For backwards compatibility
    • SQL Server: "Encrypt=No"
    • Azure SQL: "Encrypt=Yes;TrustServerCertificate=No"
  • No
    • "Encrypt=No"
  • Yes
    • Preferred option
    • "Encrypt=Yes;TrustServerCertificate=No"
  • Trust
    • "Encrypt=Yes;TrustServerCertificate=Yes"
  • Strict
    • "Encrypt=Strict"
    • SQL Server 2022 or later

The new options are stored in the Intersoft Connection string, for example:

[SQLSERVER]finPOWERConnect_finDemo_Reporting@Server;Encrypt=Yes

The change affects the following areas:

  • Database Open
    • Including ISCommonDialog.GetDatabase function.
      • Used in Global Settings, Reporting Database
  • Database Compare
  • Database Configuration File Builder
  • Database Copy
  • Database Document
  • Database Index Rebuild
  • Database Reset Permissions
  • Database Upgrade
  • Database Update Unicode