Map Intelligence with SQL Server 2008 R2, 3 Steps to Installing Report Builder 3.0.
We can view BI data against a map background by adding a map report item to a report using Report Builder 3.0 which is part of SQL Server 2008 R2 CTP. The following 3 steps show briefly how to install Report Builder.
Step 1: Install SQL Server 2008 R2 CTP and Report Builder 3.0
On successful installation of SQL Server 2008 R2 CTP, verify access to the URL's of Report Server and Reports from Reporting Services Configuration Tool. See following screenshot.
Note the Report Server mode is Native.
Issue: SSL is turned on and the report server does not accept remote an unencrypted connection. It forces the user to HTTPS. In this post, we are assuming that there is no need for an encrypted connection. We can turn off the SSL by:
Step 2: Change the ReportServer.config file's SecureConnectionLevel from "2" to "0".
<Add Key="SecureConnectionLevel" Value="0"/>
On successful installation and configuration the Report Manager Home should be displayed as shown below.
Report Manager screen with 'New Report Builder' URL, see following screenshot.
Step 3: Report Builder 3.0 can be launched in two ways;
- Start -> All Programs ->Microsoft Sql Server 2008 R2 Report Builder 3.0
- Selecting the "New Report in Report Builder" option from Report Manager URL.
Written by Swetha Sankaran, MicroLink BI Specialist