Enable HTTPS mode in SqlReportViewer and SQL Report Service

Normally, SQL Report Service (SSRS) is configured to run in HTTP by default. In this blog post, I will show you the steps required to configure the SSRS to use HTTPS mode, and how to configure the SqlReportViewer control to target the HTTPS-enabled report server.

First, you can set HTTPS mode in SSRS by clicking Advanced button.

SSRS Configuration

When configuring HTTPS, please use a valid Certificate for HTTPS. In this case, please contact your Certificate vendor.

Once SSRS has been configured HTTPS, it will look like the following screenshot.

SSRS HTTPS Configuration

Now that the SSRS server has been changed to HTTPS, the ReportServer property of the SqlReportViewer needs to be changed as well.

Example:

<Intersoft: SQLReportViewer ReportServer=”https://win7-x32-1:443/ReportServer”/>

Finally, in order to support HTTPS mode completely, you need one more additional setting in the web.config of the web application that hosts the Silverlight application. Otherwise, you will get the error below.

Error Configuration

To resolve the error, change the security mode from TransportCredentialOnly to Transport in web.config. These changes are important due to the nature of HTTPS which requires more secure communication channel.

The code in the web.config looks like the following.

Config Changes

If you have any difficulties or issues regarding this scenario, please feel free to leave your comment, or post your questions to Intersoft Community.

Warm Regards,
Handy

Advertisements

One thought on “Enable HTTPS mode in SqlReportViewer and SQL Report Service

  1. Nikki

    I live and work in the West Village and I just love that all the modernist snobs are up in arms about this truly fabulous burliing.Fdist and foremost it DOES fit into the Village because there are already so many buildings from the 20s and 30s with just this kind of Venetian style decoration all over them.Bravo we need more design that’s like this,designs that say”This is ME!”.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s