5.6

Table Of Contents
What to do next
n
Reboot the Web server machine.
Install SQLServer 2008 Utilities
The SQL Command Line Tools in the SQLServer 2008 R2 Feature Pack are required on the Web server for
a three-tier installation.
This installation also requires SQLXML to provide client-side XML functionality and enhancements to
existing SQL features. SQLXML 4.0 SP1 is installed with SQL Server 2008 R2.
Prerequisites
Verify that you can access the Microsoft Download Center to download the utilities in the following
procedure.
Procedure
1. Connect to the online Microsoft Download Center.
2. Download and install SQL Server 2008 R2 Command Line Utilities, which includes the SQLCMD utility,
X64 Package (SqlCmdLnUtils.msi).
3. Download and install the Native Client (sqlncli.msi).
Place the Web Server in the Internet Explorer Trusted Zone
To ensure that Internet Explorer can delegate the VCM user's credentials to the Web service for use with
SQL Server, you must place the VCM Web server in the Internet Explorer Trusted Zone.
When the VCM Web server is in the trusted zone, users can disable navigation into the trusted zone from
less privileged zones, which reduces the potential of cross-site scripting. When the Web server is not in a
trusted zone, the browser cannot authenticate the Web server.
Procedure
1. Open Internet Explorer.
2. Click Tools and select Internet Options.
3. Click the Security tab.
4. In the Select a zone to view or change security settings area, click Local intranet.
5. Click Sites.
6. In the Local intranet dialog box, click Advanced.
7. In the Add this website to the zone area, type the host name and click Add.
8. Click Close.
9. Click OK and click OK again.
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.
Before you configure SSRS, you must back up your SSRS key and clear the Internet Explorer Protected
Mode.
Three-Tier Split Installation
VMware, Inc.
71