5.6

Table Of Contents
Verify the SQLXML Version
SQLXML provides client-side XML functionality and enhancements to existing SQL features. SQLXML 4.0
SP1 is installed with SQL Server 2008 R2. Verify that the correct version is installed.
Procedure
1. Click Start and click Control Panel.
2. Click Programs and select Programs and Features.
3. Verify that SQLXML 4.0 SP1 appears in the list of installed programs.
4. If SQLXML 4.0 SP1 does not appear, install it from the Microsoft Download Center.
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).
What to do next
Three-tier installation configurations require you to configure additional components. See "Configuring
Additional Components for a Three-Tier Environment" on page 77.
Configuring Additional Components for a Three-Tier Environment
Three-tier installation configurations require you to configure additional components, including the
SQLCMD path variable, VCM Remote, and Collector certificates.
Modify the SQLCMD Path Variable
SQLCMD is a command-line utility that allows you to use Transact-SQL statements, system procedures,
and script files at the command prompt. To ensure that VCM Patching recognizes the SQLCMD path in a
three-tier installation, you must modify the environment variable to point to the path where SQLCMDis
installed.
In a three-tier split installation, SQLCMD is installed on the Web server, VCM Collector, and VCM
database server when you install Client Connectivity Tools or Management Tools - Basic.
Three-Tier Split Installation
VMware, Inc.
77