Install certificate to enable encrypted connections to the Database Engine in SQL Server

Kailash Chandra Behera | Wednesday, March 07, 2018

Introduction

This blog describes how to install certificate in server to Enable Encrypted Connections to the Database Engine.

Getting Started

It is very easy to install a certificate to maintain encrypted connection in SQL server. follow the below steps to get the things done.

Steps to Install Certificate

  1. On the Start menu, click Run, and in the Open box, type MMC and click OK.
  2. In the MMC console, on the File menu, click Add/Remove Snap-in.

  3. In the Add Standalone Snap-in dialog box, select Certificates and click Add.

  4. The Certificates snap-in dialog box will appear, select Computer account and then click Next button.


  5. Again select local computer and press on the Finish button.


  6. The Certificates snap-in dialog box will be closed.
  7. In the Add/Remove Snap-in dialog box, select the created certificate from the selection Snap-in and click OK.

  8. In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks, and then click Import.

    The certificate import wizard dialog box will be opened, click Next Button.

  9. Complete the Certificate Import Wizard, to add a certificate to the computer, and close the MMC console. For more information about adding a certificate to a computer, visit the link .
  10. Right-click the imported certificate, point to All Tasks, and then click Manage Private Keys. In the Security dialog box, add read permission for the user account used by the SQL Server service account.

To export the server certificate

  1. From the Certificates snap-in, locate the certificate in the Certificates / Personal folder, right-click the Certificate, point to All Tasks, and then click Export.
  2. Complete the Certificate Export Wizard, storing the certificate file in a convenient location.

Thanks

By at