Install and configure Certificates in SSRS

Install the Certificate in the Certificate Store

  1. Open Microsoft Management Console (MMC)

  1. Go to File → Add/Remove Snap-In

  2. Select "Certificates" in the left list

  1. Click Add >

  2. Specify the "Computer Account" option and click Next

  1. Specify "Local computer" and click Finish

  1. Back to the "Add or Remove Snap-in" dialog, click OK

  2. Navigate to Console Root → Certificates (Local Computer) → Personal → Certificates

9. Right-click the "Certificates" folder → All Tasks → Import

  1. The "Local Machine" option should be selected and read-only. Click Next

  1. Browse and select the certificate file and click Next

  1. If it is protected by a password, insert password and click next
  1. Select "Place all certificates in the following store" and specify "Personal" in the Certificate Store textbox and click “Next”

  1. Click “Finish”

  2. The new certificate now appear in the Certificates folder

  3. Right-click the certificate → Properties

  4. Specify a friendly name

Configure SSRS to Use the New Certificate

  1. Open "Report Server Configuration Manager"

  2. Connect to the report server (and start it if stopped)

  1. Select “Web Service URL”

  2. Change HTTPS certificate selecting the new friendly name

  1. Click Advanced

  2. Remove old certificate from web portal url

  3. Add new certificate to web portal url in both (All IPv4) and (All IPv6)

  1. Select “Web Portal URL”

  1. Click “Advanced”

  2. Remove old certificate from web portal url

  3. Add new certificate to web portal url in both (All IPv4) and (All IPv6)

  4. Click “Apply” and wait for it to process

0
Subscribe to my newsletter

Read articles from Massimiliano Figini directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Massimiliano Figini
Massimiliano Figini

data engineer • T-SQL developer • r and python • Power BI and tableau • machine learning enthusiast • data lover Follow back granted