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.

About this task

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.