For Microsoft SQL Server to support TLS 1.3, the following requirements must be met:
-
MSOLEDBSQL SQL Server is required.
-
MSOLEDBSQL version must be 19.2.0 or higher (MSOLEDBSQL19 must be selected as Provider in the database profile).
-
SQL Server must be 2022 version 16.0.4025.1 or higher. TDS 8.0 must be enabled and certificate must be configured.
SQLCA.DBMS = "MSOLEDBSQL SQL Server" SQLCA.LogPass = ******** SQLCA.ServerName = "tls.appeon.com" SQLCA.LogId = "sa" SQLCA.AutoCommit = False SQLCA.DBParm = "Database='qa_test',Provider='MSOLEDBSQL19',TrustServerCertificate=1,Encrypt=2"
For more information about TLS1.3 Support, refer to https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tls-1-3?view=sql-server-ver16.
For more information about TDS8.0, refer to https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8?view=sql-server-ver16.