SSL Certification on multiple SQL Server Instance RRS feed

  • Question

  • Hi,

    I have ONE physical server with multiple SQL instances and they are going to be part of Always On.

    Can I use ONE SSL Certificate for all the instances that are going to be part of Always On? The certificate I have created is servername.domain.com

    Thanks in advance

    Monday, January 27, 2014 8:16 PM

All replies

  • Hi Shiva Gangadhar,

    According to your description, If you want to use encryption with a failover cluster, you must install the server certificate with the fully qualified DNS name of the failover clustered instance on all nodes in the failover cluster. Usually, a X.509 certificate must be configured for each participating server node in the failover cluster with a list of all availability group listeners set in the Subject Alternate Name of the certificate. For example, if you have a two-node cluster, you must obtain a certificate and install the certificate on both nodes.

    For more information about availability group listener and SSL Certificates. you can review the following articles.

    Sofiya Li

    If you have any feedback on our support, please click here.

    Sofiya Li
    TechNet Community Support

    Tuesday, January 28, 2014 8:28 AM
  • Hi Sofiya,

    Thanks for the response. My question is now changed a little bit

    Is there an option to have one certificate per each listener? Example: If I have 2 SQL Instance Instance1 and Instance2.

    Can I have SSL1 for Instance1 and SSL2 for Instance2?

    Appreciate the response

    Tuesday, January 28, 2014 5:37 PM