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