SQL Server Certificate Requirements

This section describes the certificate requirements required for your SQL server.

SSL certificates must be:
  • Valid.
    • The date and time of the current system must be between the certificate's Valid From and Valid To properties.
  • Issued for server authentication.
  • Placed in the certificate store of the local computer.
  • The Common Name (CN) in the Subject property of the certificate must be the same as the fully qualified domain name (FQDN) of the server computer.
Note: It is not recommended that you use self-signed certificates in a production environment.