Note: Wild Card Certificates are supported.Ĭonfiguring the OpenSSL Libraries for Use (Optional) The Subject property of the certificate must indicate that the common name (CN) is the same as the host name or fully qualified domain name (FQDN) of the server computer.Usually, the certificate's key usage property (KEY_USAGE) also includes key encipherment (CERT_KEY_ENCIPHERMENT_KEY_USAGE). The certificate must be created by using the KeySpec option of AT_KEYEXCHANGE.This requires the Enhanced Key Usage property of the certificate to specify Server Authentication (1.3.6.1.5.5.7.3.1). The certificate must be meant for server authentication.The current system time must be after the Valid from property of the certificate and before the Valid to property of the certificate.Requirements for Certificatesīefore getting started, you need to make sure your certificates follow these requirements:
However, the steps to configure TLS are specific to the operating system on which SQL Server is running.
#Sql server client linux windows
SQL Server supports the same TLS protocols on both Windows and Linux: TLS 1.2, 1.1, and 1.0. SQL Server on Linux can use Transport Layer Security (TLS) to encrypt data that is transmitted across a network between a client application and an instance of SQL Server. Applies to: SQL Server (all supported versions) - Linux
0 kommentar(er)
