Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Updating SSL Certificate on SSRS Server

RSS
Modified on Wed, Jul 21, 2021, 7:44 AM by Administrator Categorized as Uncategorized

Overview

This article provides the procedure to update the SSL certificate on a SSRS (SQL Server Reporting Services) server.

Procedure

Get the CSR

(1) If this is a first-time creation, use your favorite CSR generation tool to generate the CSR. Then save the CSR in a secure place.

(2) Otherwise, retrieve the CSR you used previously.

Provision new SSL certificate

(1) Using the above CSR, provision a new SSL certificate from your favorite provider.

(2) Download/copy the SSL certificate to the SSRS server

Install the Certificate in the Certificate Store

(1) In a Command Window, type the "MMC" command and press Enter.

(2) Microsoft Management Console opens

(3) Navigate to File menu > Add/Remove Snap-In

(4) In the Add or Remove Snap-Ins dialog, select "Certificates" in the left list

(5) Click the Add button

(6) Specify the "Computer Account" option > Next

(7) Specify "Local computer" > Finish

(8) On the "Add or Remove Snap-in" dialog, click OK

(9) Navigate to Console Root > Certificates (Local Computer) > Personal > Certificates

(10) Right-click the "Certificates" folder > All Tasks > Import

(11) The "Local Machine" option should be selected and read-only.

(12) Click Next

(13) Specify the certificate file

(14) Click Next

(15) Select the "Place all certificates in the following store" option and specify "Personal"

(16) Click "Next"

(17) Click "Finish"

(18) The new certificate should now appear in the Certificates folder

(19) Right-click the certificate > Properties

(20) Edit the Friendly Name field to include the current date (I recommend a YYYY-MM-DD format)

Configure SSRS to Use the New Certificate

(1) On the Windows Start menu, run the "Report Server Configuration Manager" app

(2) Select Web Service URL

(3) For HTTPS Certificate field, choose the one with today's date (This will be the certificate you edited the Friendly Name for above.)

(4) Click the Apply button and wait for it to process.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2021, Patrick Jasinski.