User`s guide

1. Select Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
2. Click the Database Engine Query button.
3. In the SQL Query pane, type SELECT @@Servername and click Execute.
4. Verify that the resulting server name matches the machine name. If the server name does not match
the machine name, you must reconfigure your machine so that the machine name matches the server
name described in Reset the SQL Server Name.
Reset the SQL Server Name
If the SQL Server server name does not match the Collector machine name, reset the SQLServer name.
You cannot perform this procedure after you install VCM.
NOTE If you reset the SQL Server name, you must reconfigure SSRS to connect to the new SQL Server
instance.
1. Select Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.
2. Click the Database Engine Query button.
3. In the SQL Query pane, type this command and replace NewServerName with the desired server
name:
exec sp_dropserver @@SERVERNAME
exec sp_addserver 'NewServerName', 'local'
NOTE You cannot install VCM on a machine where the machine name or SQL Server server name
includes an underscore.
4. Restart the SQL Server service. Select Start > Programs > Microsoft SQL Server 2008 R2 >
Configuration Tools > SQL Server Configuration Manager > SQL Server 2008 R2 Services.
5. Right-click SQL Server (MSSQLSERVER or your named instance) and select Restart.
Use SQL Server 2008 Reporting Service (SSRS)
You do not need to configure SQL Server 2008 Reporting Services because the settings are configured for
you during installation. If you need to manage SQL Server 2008 Reporting Services or change any settings,
open the Reporting Services Configuration Manager.
Before you use SSRS, back up your configurations using the instructions described in Back Up Your SSRS
Key.
Internet Explorer Protected Mode and SSRS
On the VCM Collector, when User Account Control (UAC) is turned on and Internet Explorer Protected
Mode is enabled, errors related to SSRS user permissions and web service errors on dashboards and node
summaries can occur. If you access the VCM Web console from any machine other than the Collector, this
issue does not occur. Access to the SSRS administration interfaces, http://localhost/reports, is also
blocked by Protected Mode and UAC.
VMware recommends that you do not use the VCM Web console from the Collector itself because either
the VCM SSRS dashboards will not be usable or Internet Explorer security on the Collector must be
reconfigured to allow the dashboards to operate. To enable SSRS dashboards on the Collector, either
disable Internet Explorer Protected Mode for the zone of the Collector itself or run Internet Explorer as
administrator. Do not use these options for general use because they can increase the exposure of the
Collector to attacks through Internet Explorer.
Software and Operating System Requirements for Collector Machines
VMware, Inc. 35