5.6

Table Of Contents
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.
5. If the SQL Server name does not match the Windows machine name, reset the SQL Server name.
a. In the SQL Query pane, type the following command and replace NewServerName with the server
name.
exec sp_dropserver @@SERVERNAME
exec sp_addserver 'NewServerName', 'local'
b. Click Execute.
c. To restart the SQL Server services, click Start and select Programs > Microsoft SQL Server 2008
R2 > Configuration Tools > SQL Server Configuration Manager > SQL Server 2008 R2
Services.
d. Right-click SQL Server and click Restart.
6. Reboot the database server machine.
What to do next
Verify that the SQL Server Agent service account has the SQL Server sysadmin role. See "Verify the
SQLServer Agent Service Account is a sysadmin" on page 45.
Verify the SQLServer Agent Service Account is a sysadmin
The SQL Server Agent service account that runs scheduled jobs in SQL Server must be a sysadmin.
Procedure
1. Click Start and select All Programs.
2. Click Microsoft SQL Server 2008 R2 and select SQL Server Management Studio.
3. Expand the server, expand Security, expand Server Roles.
4. Double-click sysadmin and view the members of the sysadmin role.
5. Verify that the account to use for the SQL Server Agent service is a member of the sysadmin fixed
role.
6. If the account is not a member of the sysadmin fixed role, add this role to the account.
What to do next
Select the SQL Server Agent service account See "Select the SQLServer Agent Service Account" on page 46.
vCenter Configuration Manager Advanced Installation Guide
45
VMware, Inc.