5.6

Table Of Contents
Wizard Page Action
Installation
Configuration
Rules
Verify that the rules passed. To view the detailed system configuration check
report, click the link.
Ready to
Install
Review the summary of features and click Install to install SQL Server 2008 R2.
When the installation is finished, click the link to view the log file.
What to do next
n
Reboot the single-server machine.
n
Configure the SQLServer properties. See "Verify and Configure the SQL Server Properties" on page 44.
Verify and Configure the SQL Server Properties
To ensure that SQLServer will operate with VCM, verify the SQLServer property settings and set the
server-wide SQL database settings in preparation to install VCM. For information about server-wide and
database-specific SQL Server database settings, see the VCM Administration Guide.
Procedure
1. Click Start and select All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management
Studio.
2. Right-click the SQL instance and select Properties.
3. Confirm the General page server properties.
a. Verify that the Version is 10.50.1600.1
b. Verify that the Language is English (United States).
If the language is not correct, uninstall and install the correct version of SQL Server.
c. Verify that the Server Collation is SQL_Latin1_General_CP1_CI_AS.
If the server collation is not correct, uninstall and reinstall SQL Server.
4. Select and confirm the Security page server properties.
a. Select Windows Authentication mode, which is recommended.
b. Although SQL Server and Windows Authentication mode is acceptable for VCM, select Windows
Authentication mode, which is recommended.
5. Select and confirm the Database Settings page server properties.
a. For Default index fill factor, type or select a percentage value, which specifies the amount of free
space in each index page when the page is rebuilt.
Set the fill factor to 80% to keep 20% free space available in each index page.
b. For Recovery interval (minutes), type or select 5.
6. Click OK to save your changes.
What to do next
To ensure that SQLServer and VCMoperate correctly together, verify that the SQLServer name matches
the Windows machine name. See "Verify Matching SQL Server and Computer Names" on page 45.
Single-Tier Server Installation
VMware, Inc.
44