Installation guide
Use of a shared SQL Server is supported for VCM. However, VCM makes heavy use of SQL Server for
query and transaction processing. You must ensure that you have or can add enough capacity to a shared
SQL Server so that VCM and any other databases on the shared server do not experience poor
performance.
VCM operates with a Standard or Enterprise edition of SQL Server. You must install the 64-bit SQL Server
2008 R2 or 2012 version on your designated database server machine and verify that the settings are
configured correctly for a VCM installation.
If you plan to change the communication port that SQL Server uses from the default port of 1433 to a
nonstandard port number, make the changes during the installation of SQL Server and SQL Server
Reporting Services (SSRS). Changing the port after you install SSRS disables SSRS communication with
SQL Server, which causes an SSRS validation error during the VCM installation process. If you change the
port after installation, you must configure additional SSRS settings to repair the configuration.
Install SQL Server on the VCMCollector
In a single-tier installation configuration, the VCM database server resides on the same server on which
you install VCM. The database server contains the VCM, VCM_Coll, VCM_Raw, and VCM_UNIX
databases. You must configure the VCM database server before you install VCM in a single-tier
installation configuration.
NOTE Do not run VCM in a production environment when using only an evaluation version of SQL
Server. Evaluation versions are not supported for production.
Prerequisites
n Obtain the installation media for the Enterprise or Standard edition of SQL Server 2008 R2 or 2012, or
verify access to a file share where the installer resides.
Procedure
1. Start the SQLServer installation.
2. Perform the following actions to install SQL Server.
Wizard Page Action
SQL Server
Installation
Center
Click New installation or add features to an existing installation.
Setup Support
Rules
Click Install and verify that all of the rules pass. To view the detailed system
configuration check report, click the link.
Setup Support
Files
Click Install to install the setup support files.
Setup Support
Rules – for
SQL Server
Setup support
files
Verify that all of the rules passed.
Installation
Type
Select New installation or add shared features.
Single-Tier Server Installation
VMware, Inc.
45