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.

Before you begin

Verify that the vRealize Automation SQL Server database exists. Begin with Choosing an IaaS Database Scenario.

About this task

One reason to change run-time authentication might be when, for example, the database is on an untrusted domain.

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.