Importing the TLS certificate from System Manager to Microsoft SQL Servers

Last Updated : Aug 14, 2023 |

About this task

Use this procedure to import Transport Layer Security (TLS) certificate from System Manager to Microsoft SQL Servers to enable AlwaysOn EDM DB HA.

Procedure

  1. Log in to the primary Avaya Control Manager SQL Server.
  2. Copy the relevant P12 certificate file from System Manager to a folder on the SQL Server node.
  3. Navigate to the folder containing the P12 file.
  4. To open the Certificate Import Wizard page, do one of the following:

    • Double-click the P12 file.

    • Type certlm.msc in the Windows Search window. On the Certificates-Local Computer page, right-click Personal and click All Tasks > Import.

    The Certificate Import Wizard page opens.

  5. On the Certificate Import Wizard page, do the following:
    1. Select Local Machine and click Next.
    2. Click Browse, specify the file to import, and click Next.
    3. To maintain the private key security, in the Password field, enter the password that you use while creating an end entity in System Manager.
    4. Select the Include all extended properties check box and click Next.
    5. To select the personal certificate store where you save the certificate, select Certificate Store Selected by User.
    6. Click Finish.
  6. On the Certificates-Local Computer page, right-click Personal > Certificates.
  7. Double-click the required certificate.
  8. Click the Details tab.
  9. Click Edit Properties and enter a name for the certificate.
    Tip:

    You must save only one certificate in the personal folder of your Microsoft SQL Server so that you can choose this certificate instantly while enforcing the TLS connection.

  10. Repeat Steps 1 to 17 for the secondary SQL Server.

    Follow these steps using a unique certificate created for each server as mentioned in Downloading Transport Layer Security certificate from System Manager.