7.1

Table Of Contents
Machine Manager\bin" />
[...]
</assemblies>
</assemblyLoadConfiguration>
Procedure
1 Stop the DEM Worker.
2 Determine the installation path.
3 Update the DynamicOps.DEM.exe.config le.
4 Restart the DEM Worker.
The default DEM Worker path is updated to the new folder.
Configuring Windows Service to Access the IaaS Database
A system administrator can change the authentication method used to access the SQL database during run
time (after the installation is complete). By default, the Windows identity of the currently logged on account
is used to connect to the database after it is installed.
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.
Installing vRealize Automation
94 VMware, Inc.