E. Click on YES to complete F. We need to make a note of the Id’ from the below screen. ‘Request Issue the certificate. A. In MMC add Authority’ using Snap-in’ options. ‘Certificates’&’Certificate ‘Add/Remove B. Click on 'Pending requests' in 'Certificate Authority'. (We would see certificate with Request ID which we generated in STEP 5.i.e., 7 here) C. Right click on the certificate --> All Tasks --> ISSUE D. Now we should see the certificate under Certificates’ ‘Issued Install the certificate A. Click on 'View the status of a pending certificate request' B. Click on the certificate. C. Click on 'Install this certificate' D. Click on YES E. We will see the successfully installed screen. Assign the certificate to the SQL Server instance. A. Open SQL Server Configuration Manager B. Right click on on <instance name>‘ ‘Protocol (for the instance which we need, here it is STANDARD) C. In the certificate tab and select the certificate we created earlier. D. Click on Apply and restart the SQL Server instance to get this change applied. After the successful deployment of the certificate (Server side) we should see the below message in our SQL Error Log file during the server startup. The certificate was successfully loaded for encryption.
E. Click on YES to complete F. We need to make a note of the ‘Request Id’ from the below screen. Issue the certificate. A. In MMC add ‘Certificates’&’Certificate Authority’ using ‘Add/Remove Snap-in’ options. B. Click on 'Pending requests' in 'Certificate Authority'. (We would see certificate with Request ID which we generated in STEP 5.i.e., 7 here) C. Right click on the certificate --> All Tasks --> ISSUE D. Now we should see the certificate under ‘Issued Certificates’ Install the certificate A. Click on 'View the status of a pending certificate request' B. Click on the certificate. C. Click on 'Install this certificate' D. Click on YES E. We will see the successfully installed screen. Assign the certificate to the SQL Server instance. A. Open SQL Server Configuration Manager B. Right click on ‘Protocol on <instance name>‘ (for the instance which we need, here it is STANDARD) C. In the certificate tab and select the certificate we created earlier. D. Click on Apply and restart the SQL Server instance to get this change applied. After the successful deployment of the certificate (Server side) we should see the below message in our SQL Error Log file during the server startup. The certificate was successfully loaded for encryption.
SSL_Certificate.docx