Installation guide

Installing and Configuring SSRS on the Web Server
SQL Server Reporting Services (SSRS) is a server-based report generation software system that is
administered using a web interface and used to deliver VCM reports.
Back Up Your SSRS Key
The rskeymgmt utility manages the symmetric keys used by a report server. This utility provides a way to
delete encrypted content that can no longer be used if you cannot recover or apply the key.
Use the Microsoft command-line utility to back up the symmetric key to an encrypted file.
Prerequisites
n See the online Microsoft Support center for details about how to use the rskeymgmt utility.
Procedure
1. On the Collector file system, locate the rskeymgmt.exe utility at c:\Program Files (x86)
\Microsoft SQLServer\100\Tools\Binn or the directory where you installed SQLServer.
2. To copy your SSRS key set to a removable media device and store it in a secure location, open a
command line prompt and run the rskeymgmt.exe utility with the appropriate options.
Disable IE Protected Mode for SSRS
On the VCM Collector, when User Account Control (UAC) is turned on and Internet Explorer Protected
Mode is enabled, SSRS user permissions errors and Web service errors on dashboards and node
summaries can occur. UAC and Internet Explorer Protected Mode also block access to the
http://localhost/reports SSRS administration interfaces. If you use another machine to access the VCM Web
console interface, this problem does not occur.
CAUTION Do not use the VCM Collector Web console interface for general Internet access, because
doing so causes VCM SSRS dashboard errors. If you access the Internet through the VCM Collector
Web console interface, to enable the SSRS dashboards you must either disable Internet Explorer
Protected Mode for the zone of the Collector or run Internet Explorer as administrator.
Do not modify the Internet Explorer Protected Mode setting in other circumstances, because doing
so reduces the protection on the Collector and can increase the exposure of the Collector to attacks
through Internet Explorer.
Procedure
1. In Internet Explorer, click Tools.
2. Click Internet Options and click the Security tab.
3. Click Local intranet and deselect the Enable Protected Mode (requires restarting Internet Explorer)
check box.
4. Click Apply and OK, and close all instances of Internet Explorer.
Install SQL Server Reporting Services
In a three-tier installation configuration, for the Web server to generate VCM reports, install SQL Server
Reporting Services (SSRS).
Three-Tier Split Installation
VMware, Inc.
103