5.6

Table Of Contents
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 68.
Verify Matching SQL Server and Computer Names
To ensure that SQLServer and VCM operate correctly together, you must verify that the SQLServer
name matches the Windows machine name. If you recently installed SQL Server 2008 R2, you do not need
to verify that the names match. If you obtained a machine that was renamed after the operating system
and SQL Server 2008 R2 were installed, verify and reset the SQLServer server name.
Procedure
1. Click Start and select All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management
Studio.
2. Click Database Engine Query.
3. In the SQL Query pane, type SELECT @@Servername and click Execute.
4. Verify that the resulting SQL Server name matches the Windows machine name.
Two-Tier Split Installation
VMware, Inc.
68