none
Using SSL for SQL server with multiple instances

    Question

  • Hello,

    If there are more than one instance (say 3 or 4 instances of SQL2k12 or above), what is the best way to bind the SSL certificate to those services?

    Typically, only one SSL certificate is issued to a common name of the concerned SQL server. However, if there are multiple instances running on the same server, wondering whether we can bind the same SSL to those multiple instances or we need to think about alternatives such as using subject name alternatives etc.?

    Your input will be greatly appreciated.

    Thanks.

    Victor


    Victor

    Tuesday, July 3, 2018 11:16 PM

Answers

  • Dear vr123,

    When these instances are installed on the same server, they should can use the same SSL certificate. On the same machine, the fully qualified domain name (FQDN) is same.

    The method using subject name alternatives you mentioned is a method which meets the requirement for one certificate, multiple server.

    Best Regards,

    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by vr123 Wednesday, July 4, 2018 1:59 PM
    Wednesday, July 4, 2018 7:31 AM
    Moderator

All replies

  • Dear vr123,

    When these instances are installed on the same server, they should can use the same SSL certificate. On the same machine, the fully qualified domain name (FQDN) is same.

    The method using subject name alternatives you mentioned is a method which meets the requirement for one certificate, multiple server.

    Best Regards,

    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by vr123 Wednesday, July 4, 2018 1:59 PM
    Wednesday, July 4, 2018 7:31 AM
    Moderator
  • Thanks Teige. Appreciate the quick response.

    Victor


    Victor

    Wednesday, July 4, 2018 1:59 PM