Installation guide

Procedure

1. Click Start and select All Programs.

2. Click Microsoft SQL Server {version} > 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

Verify that the SQL Server Agent service is configured to start automatically. See "Verify that the

SQLServer Agent Service Starts Automatically" below.

Verify that the SQLServer Agent Service Starts Automatically

VCM uses the SQL Server Agent service to run all scheduled jobs and SSRS reports, including dashboards.

Set the service to automatically start on the VCM server where SQL Server is installed.

Procedure

1. On the VCM database server, click Start and select Administrative Tools > Services.

2. Right-click SQL Server Agent, and select Properties.

3. From the Startup type menu, select Automatic.

4. Click OK, and close the Services window.

What to do next

Select the SQL Server Agent service account See "Select the SQLServer Agent Service Account" below.

Select the SQLServer Agent Service Account

SQL Server Agent is a service that runs scheduled jobs in SQLServer and runs as a specific user account.

Verify that the SQL Server Agent service account that you provided during the SQL Server installation is a

SQL Server sysadmin. The SQL Server Agent runs as a user account.

Prerequisites

n Verify that the account you provide for the SQL Server Agent service has permission to log in as a

service and the required additional permissions. See the online Microsoft Developer Network for more

information.

n Understand the supported service account types for non-clustered and clustered servers. VCM 5.7

supports Active/Active SQL clusters. See the online Microsoft Developer Network for more

information.

n Verify that the account you will use for the SQL Server Agent service account has the sysadmin

privilege. See "Verify the SQLServer Agent Service Account is a sysadmin" on page 69.

vCenter Configuration Manager Advanced Installation Guide

VMware, Inc.