7.2

Table Of Contents
Enable IaaS Database Access from the Service User
If the SQL database is installed on a separate host from the Manager Service, database access from the
Manager Service must be enabled. If the user name under which the Manager Service will run is the owner
of the database, no action is required. If the user is not the owner of the database, the system administrator
must grant access.
Prerequisites
n
“Choosing an IaaS Database Scenario,” on page 77.
n
Verify that the user name under which the Manager Service will run is not the owner of the database.
Procedure
1 Navigate to the Database subdirectory within the directory where you extracted the installation zip
archive.
2 Extract the DBInstall.zip archive to a local directory.
3 Log in to the database host as a user with the sysadmin role in the SQL Server instance.
4 Edit VMPSOpsUser.sql and replace all instances of $(Service User) with user (from Step 3) under which
the Manager Service will run.
Do not replace ServiceUser in the line ending with WHERE name = N'ServiceUser').
5 Open SQL Server Management Studio.
6 Select the database (vCAC by default) in Databases in the left-hand pane.
7 Click New Query.
The SQL Query window opens in the right-hand pane.
8 Paste the modied contents of VMPSOpsUser.sql into the query window.
9 Click Execute.
Database access is enabled from the Manager Service.
Configure the Windows Services Account to Use SQL Authentication
By default, the Windows service account accesses the database during run-time, even if you congured the
database for SQL authentication. You can change run-time authentication from Windows to SQL.
One reason to change run-time authentication might be when, for example, the database is on an untrusted
domain.
Prerequisites
Verify that the vRealize Automation SQL Server database exists. Begin with “Choosing an IaaS Database
Scenario,” on page 77.
Procedure
1 Using an account with administrator privileges, log in to the IaaS Windows server that hosts the
Manager Service.
2 In Administrative Tools > Services, stop the VMware vCloud Automation Center service.
3 Open the following les in a text editor.
C:\Program Files (x86)\VMware\vCAC\Server\ManagerService.exe.config
C:\Program Files (x86)\VMware\vCAC\Server\Model Manager Web\Web.config
4 In each le, locate the <connectionStrings> section.
Installing vRealize Automation
96 VMware, Inc.