Configure the Windows Services Account to Use SQL Authentication

By default, the Windows service account accesses the database during run-time, even if you configured 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.

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 files 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 file, locate the <connectionStrings> section.
5. Replace

   Integrated Security=True;

   with

   User Id=database-username;Password=database-password;

6. Save and close the files.

   ManagerService.exe.config
   Web.config

7. Start the VMware vCloud Automation Center service.
8. Use the iisreset command to restart IIS.