Self-Signed Certificate using WEB IIS Server – SSRS/PBIRS

Self-Signed Certificate: Coming to use of SSRS/PBIRS with HTTPS are the two most popular reporting services offered by Microsoft. When it comes to SSRS/PBIRS configuration for web SSL (https:) then we need certificate. Be with us and follow all the steps to create self-signed certificates, that can configure the SSRS/PBIRS URL with HTTPS.

Steps to create Self-Signed Certificate

Approach 1:

Step 1: First download the WEB IIS Server from the Microsoft website or you can directly download from this link: Download IIS 10.0 Express from Official Microsoft Download Center

image 25

Step 2: Install and search in the windows search as ” IIS “ and open the application to proceed further.

image 31

Step 3: In the left-pan you can see that my VM is visible as internet server, click on that and in the middle box you can find “server certificates”. Right click on server certificate and you will find “open feature option” click on the that.

Self-Signed Certificate

Step 4: In the right-side window you can find “Create Self-Signed Certificates” click on that and go to next step.

Self-Signed Certificate

Step 5: Give any name to your certificate, so that it should be recognizable later when you configure in SSRS/PBIRS.

image 27

Step 6: As you can see that your self-signed certificate is created and also applied to this VM/Machine. Now you can use this Certificate in in any for your application. Scroll below to see the use of this certificate in SSRS/PBIRS.

Self-Signed Certificate

Step 7: As you can see that I have opened my SSRS Instance and when I go to web service URL and try to configure the HTTPS, the certificate which I created is listed here. Now we will configure and good to go for self-signed-certificate.

ssrs/pbirs

Approach 2:

Self-Signed Certificate using PowerShell.

Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)

Approach 3:

Turn-on IIS in Windows

Open control panel — > Turn Windows Features on or off

image 2

Click the check box of internet information services—> Ok

image 3

Open Windows search bar Type IIS open and double click on server certificate it will open other window –> Right side click on create self-singed certificate.

image 4

Give Random name and click okay and configure the certificate in SSRS or PBIRS.

Conclusion:

Hope this article helped you in creating the self-signed certificate for your requirement. The requirement is to have SSL on the SSRS/PBIRS URL’s then this is best article with the required explanation. Creating SSL for SSRS/PBIRS is not only limited to this, but you can also use self-signed certificates for other purpose as well. If you have any concern or doubt, please feel free to comment it down.

MSBi Links:

  1. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  2. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  3. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  4. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  5. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  6. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  7. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  8. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  9. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  10. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  11. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  12. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  13. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  14. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  15. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 112

Leave a Reply

Your email address will not be published. Required fields are marked *