Create an association between the signed certificate and its corresponding key pair

this section shows how to associate the signed microsoft sql server certificate with its corresponding private key stored in your windows account profile before making this association, you must import the ca certificate that issued the microsoft sql server certificate into the trusted root certification authorities windows certificate store import the ca certificate perform the following steps to import the ca certificate that issued the microsoft sql server certificate into the trusted root certification authorities store on the computer where you plan to install microsoft sql server, open the manage computer certificates program right click the trusted root certification authorities store and select all tasks > import follow the steps in the certificate import wizard to import the root ca certificate file that you exported from the {{k}} and moved to this computer in the previous section you should see a confirmation message if the import is successful associate the certificate perform the following steps to associate the signed microsoft sql server certificate with its corresponding private key stored in the user's windows account profile open either the command prompt or powershell go to the directory where you saved the signed microsoft sql server certificate file run the following command to create an association between the signed microsoft sql server certificate and its corresponding key pair stored in your windows account profile certreq accept user signed sqlserver cert pem if the command succeeds, information about the installed certificate displays the screen