5.6

Table Of Contents
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
n
Reboot the database server machine.
n
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 94.
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.
Open SQLServer Management Studio and verify that the account you will use for the SQL Server Agent
service account has the sysadmin privilege.
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 95.
Three-Tier Split Installation
VMware, Inc.
94