7.0

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.
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 modified 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 services account accesses the database during run-time, even if you created the
database using SQL authentication. A system administrator can change the run-time authentication
method from Windows, to SQL, when the database is on an untrusted domain, for example.
Prerequisites
Choosing an IaaS Database Scenario.
Procedure
1 Log in to the Manager Service host as a local user with administrator privileges.
2 Stop the vCloud Automation Center service.
Installing vRealize Automation
VMware, Inc. 98