Manualshelf

User`s guide

ManualsBrandsVMware ManualsOtherVCM 5.3 - TRANSPORT LAYER SECURITY IMPLEMENTATION
21222324252627282930
Verify Matching SQL Server and Computer Names
Verify that the SQLServer name matches the computer name. If you just installed SQL Server 2008 R2, this
step is not necessary. If you obtained a machine that was renamed after both the operating system and
SQL Server 2008 R2 were installed, you must verify and reset the server name.
Procedure
1. Click Start and select 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, you must reset the SQLServer
name. If you reset the SQL Server name, you must reconfigure SSRS to connect to the new SQL Server
instance.
You cannot perform this procedure after you install VCM.
Procedure
1. Click Start and select 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.
Click Start and select 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.
Prerequisites
Before you use SSRS, back up your configurations. See "Back Up Your SSRS Key" on page 26.
Software and Operating System Requirements for Collector Machines
VMware, Inc.
25