How to Setup SSRS to Use HTTPS – Part 2

This blog post is a continuation from last week’s post where I left off after showing you how to prepare SQL Server Reporting Services (SSRS) for the server (website) certificate. In this post, Part 2, I show you how to complete the process of setting-up SSRS to use HTTPS.

If you recall, in Part 1, I covered all of the steps needed to request the server certificate for use with SSRS and showed you how to setup SSRS to use the Network Service account. Next, in this post, I show you how to setup SSRS to use the server certificate for HTTPS, test the SSRS website and then I tell you how to clean-up the SSRS site if you get an “OLD” folder.

The overall process is as follows:

· Install the IIS Management Console.

· Import the server certificate from your domain certificate authority.

· Prepare SSRS for the server certificate

· Setup SSRS to use the server certificate.

· Test the SSRS website.

· Clean-up.

Setup SSRS to Use HTTPS Prerequisites

In order to put together this step-by-step guide, I created a new virtual machine (VM) {cm-rps-cb1} and then installed SQL Server 2017 (How to Install SQL Server 2017). Next, I installed SSRS itself (How to Install SQL Server Reporting Services 2017) and then finally, I installed the SCCM Reporting Services Point (How to Install a SCCM Reporting Services Point). Long ago, I setup a domain certificate authority in my domain, so you should have done the same too. This is my starting point.

Before continuing, make sure that you review and complete the steps within the first blog post, How to Setup SSRS to Use HTTPS – Part 1.

Setup SSRS to Use the Server Certificate

SSRS to Use HTTPS - Web Service URL Node

Open Report Server Configuration Manager and select the Web Service URL node.

SSRS to Use HTTPS - HTTPS Certificate Drop-Down

In the HTTPS Certificate drop-down, select the friendly name of the certificate that you created earlier.

SSRS to Use HTTPS - Apply Button

Click on the Apply button and wait for the results to complete. This might take several minutes.

SSRS to Use HTTPS - Warning Message

Warning Message:

The specified url was unexpectedly reserved. The previous reservation has been overridden.
The specified url may have been reserved by another product.

If you receive this warning message, click OK to continue. I found that this warning message does not cause any issues. I recommend, however, testing the URL to confirm that it works correctly. I cover how to do that in the next section.

SSRS to Use HTTPS - Web Portal URL

Click on the Web Portal URL node. Next, click Advanced.

SSRS to Use HTTPS - Multiple HTTPS Identities

Under the Multiple HTTPS Identities for the currently Reporting Services feature, click on the Add button.

SSRS to Use HTTPS - Certificate Drop-Down

Select the Certificate drop-down and choose the friendly name of the certificate that you created earlier. If you want (All IPv6) addresses too, select that from the IP Address drop-down.

Click OK.

SSRS to Use HTTPS - OK Button

Click OK.

SSRS to Use HTTPS - Results Window

Wait for the Results window to say: The task completed successfully.

Make note of the HTTPS URL above. You will need to remember it when you go to test the SSRS website in the next section.

Test the SSRS Website

SSRS to Use HTTPS - Report Server Web Service URLs

Back on the Web Service URL node, click on the HTTPS URL listed in the Report Server Web Service URLs section. In my case, it is https://cm-rps-cb1/ReportServer.

SSRS to Use HTTPS - ReportServer URL

This action launches a browser and connects to the ReportServer URL. A successful install looks similar to the one above.

If you see ConfigMgr_<site code>.OLD.* this means that the SCCM Reporting Point was active during the update to HTTPS, so this folder can be deleted. Details about how to delete the folder are covered a bit later on in this blog post.

SSRS to Use HTTPS - Reports

Next, add the text, “Reports,” to the end of the URL and hit Enter in order to continue. This URL should match the URL that you noted previously in the Web Portal URL section. In my case it is: https://cm-rps-cb1/Reports.

SSRS to Use HTTPS - SSRS Site

A successful site looks similar to the image above.

Using the same URL, https://cm-rps-cb1/Reports, browse to the HTTPS site from a remote computer. This test should also be successful, but if not, check your firewall ports. If you need additional help, check out my post, Why Can’t I Access My SSRS Site Remotely? It is written for HTTP, but the steps still apply for HTTPS, except instead of using port 80, use 443. Everything else in that blog post is the same for HTTPS.

With that last step successfully completed, SSRS is leveraging HTTPS.

Clean-up: How to Delete ConfigMgr_<site code>.OLD.*

Initially, I was going to show you how, in this post, to clean-up the “OLD” folder. Lo and behold, I found out that I already published a post, not too long ago, on how to do that! Please check out, “How to Delete SSRS Reports and Folders,” for more details.

Lastly, I would like to thank Niall Brady for giving me the excuse to write this blog post. If you have any questions about how to setup SSRS to use HTTPS, please feel free to touch base with me @GarthMJ.

Leave a Comment

Share via
Copy link
Powered by Social Snap