Setting up Microsoft SQL Server 2008 Reporting Services and Silverlight
Viewer for Reporting Services 2008 for work over secured protocol (SSL)
- .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
- Microsoft SQL Reporting Services Sample Reports
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.
Setting up “Internet Information Services”.
To get the certificate you need to use Internet Information
In the Control Panel, select the item “Programs and
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
It is necessary to select the following elements for the
“Internet Information Services”:
- Web Management Tools
- World Wide Web Services
- Application Development Features
- .NET Extensibility
- 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
- Basic Authentication
- Request Filtering
- Windows Authentication
In order to apply changes click “OK”.
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
Setting up Microsoft SQL Server 2008 Reporting Services.
In order to open Configuration manager for Reporting
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”.
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
After you save configuration file (Ctrl+S), run the project
When the report is loaded and formed it will be displayed in
ssrs Silverlight Viewer for Reporting Services