Setting up Microsoft SQL Server 2008 Reporting Services and Silverlight Viewer for Reporting Services 2008 for work over secured protocol (SSL)

Prerequisites

• .NET Framework 3.5 SP1/4.0
• Silverlight v5
• Silverlight v5 SDK
• Silverlight v5 Developer Tool
• Visual Studio 2008/2010/2012
• Microsoft SQL Server 2008/2012 Reporting Services (Enterprise or Standard editions)
• Microsoft SQL Reporting Services Sample Reports

Attachment

SilverlightViewerForReportingServices2008GettingStartedExample.zip

In order to set up Microsoft SQL Server 2008 Reporting Services SSL certificate is required. If the system features necessary SSL certificate, steps 1 and 2 may be omitted.

Step 1

Setting up “Internet Information Services”.

To get the certificate you need to use Internet Information Services.

In the Control Panel, select the item “Programs and Features”.

Select the item “Turn Windows Features on or off” in the menu of the appeared window.

In the list of additional Windows components, drill down a list of additional components by double click on the element “Internet Information Services”.

It is necessary to select the following elements for the “Internet Information Services”:

• Web Management Tools
  
  • IIS Management Console
• World Wide Web Services
  
  • Application Development Features
    • .NET Extensibility
    • ASP
    • ASP.NET
    • ISAPI Extensions
    • ISAPI Filters
  • Common HTTP Features
    • Default Document
    • Directory Browsing
    • HTTP Errors
    • Static Content
  • Health and Diagnostics
    • HTTP Logging
    • Request Monitor
  • Performance Features
    • Static Content Compression
  • Security
    • Basic Authentication
    • Request Filtering
    • Windows Authentication

In order to apply changes click “OK”.

Step 2

Creating SSL certificate.

After the changes are saved to the system, select the element “Administrative Tools” in the Control Panel.

Double click on the element “Internet Information Services (IIS) Manager” in order to open manager of the “Internet Information Services”.

Double click on the "Server Certificates" in the IIS Manger.

If there are certificates in the list, you can use them and proceed to the Step 3.

If there are no certificates, you need to add it – double click on the element “Create Self-Signed Certificate”.

Enter name of the created certificate and click “OK”.

After the certificate is created it is added to the server certificate list.

Step 3

Setting up Microsoft SQL Server 2008 Reporting Services.

In order to open Configuration manager for Reporting Services, select

Start–>All Programs–>Microsoft SQL Server 2008–>Configuration Tools->Reporting Services Configuration Manager.

Select connection parameters (Server Name – name of the computer on which the server works, Report Server Instance – name of the report server). Press button "Connect".

In the left menu, select “Web Service URL” by double click.

Select the created certificate “ReportingServicesSSL” or pre-existing certificate from the list “SSL Certificate”.

To apply changes click “Apply”.

After the server sets up the element “Report Server Web Services URLs” will feature active hyperlink to the secured page.

In order to check work over the secured protocol, use URL started from https://....

Windows may require entering “User Name” and “Password” of the current user. After you enter “User Name” and “Password” click “OK”.

Browser will display contents of the virtual directory. Default directory name is “Report Server”.

Step 4

Setting up project for work over the secured protocol (SSL).

In order to create a project it is necessary to go through steps 1 to 8 from the “Getting started with Silverlight Viewer for Reporting Services 2008”.

When these steps from “Getting started with Silverlight Viewer for Reporting Services 2008” are done set up ASP project for work with Reporting Services over the secured protocol. Open project configuration file – double click on the Web.config file. In the project configuration file, change section MsReportingServer to look like this:

Instead of “host.domain/ReportServer” you need to enter path used to transfer from the "Reporting Services Configuration Manager" over the secured protocol.

After you save configuration file (Ctrl+S), run the project Crtl+F5.

When the report is loaded and formed it will be displayed in the browser.