Importing CA-Signed Certificates

In Windows Explorer on the SQL Server database client machine, locate the database server CA certificates which you obtained.

Follow the below steps to import each of the database server certificates into Trusted Root Certificates authorities of the Client machine:

  1. Right click on a CA certificate.
  2. Click on Install Certificate.
    This image shows the step to install CA certificate

  3. On Welcome to the Certificate Import Wizard, click the radio button for Local Machine and click the Next button to continue.
    This image shows the Certificate Import Wizard

  4. When you are prompted for the Certificate Store, choose Place all certificates in the following store.
  5. Select the Trusted Root Certification Authorities store.
  6. Complete the remaining steps of the wizard and click the Finish button.