A new encryption type "Strict" is added to the Encrypt Data option in the DB profile. The "Strict" encryption type enables SQL Server 2022 to leverage TDS 8.0. 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.
"Strict" is available when you select the following SQL Server drivers:
-
OLE DB Driver for SQL Server (MSOLEDBSQL 19.x)
SQLCA.DBMS = "MSOLEDBSQL SQL Server" SQLCA.AutoCommit = False SQLCA.DBParm = "Provider='MSOLEDBSQL19',Encrypt=2" -
ADO.NET provider for SQL Server
SQLCA.DBMS = "ADO.Net" SQLCA.AutoCommit = False SQLCA.DBParm = "Provider='SQL Server',PROVIDERSTRING='Encrypt=Strict;'" -
MSOLEDBSQL 18.x does NOT support the "Strict" type.
-
SNC SQL Native Client does NOT support the "Strict" type.
For more information, refer to the section called “Encrypt”.
Strict encryption is also supported in PowerServer. View here for more information.
