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.

Procedure

  1. Log in to the Manager Service host as a local user with administrator privileges.
  2. Stop the vCloud Automation Center service.
  3. Navigate to the Server directory.

    C:\Program Files (x86) \VMware\vCAC\Server\

  4. Open the ManagerService.exe.config file in a text editor.
  5. In the connectionStrings section and the serviceConfiguration serviceURIsection, replace Integrated Security=True with User Id=DATABASE_USER;Password=DATABASE_PASSWORD.
  6. Save and close the file.
  7. Navigate to C:\Program Files (x86)\VMware\vCAC\Server\Model Manager Web\.
  8. Open the Web.config file in a text editor.
  9. Locate the repository server section.
     <repository server="localhost" database="vCAC" store="https://vcac.example.com/" />
  10. Add the database user command.

    user=DATABASE_USER password=DATABASE_PASSWORD. For example:

     <repository server="localhost" database="vCAC" user="sqlUser" password="sqlPassword" store="https://vcac.example.com/" />

  11. Save and close the file.
  12. Start the vCloud Automation Center Service.

Results

SQL server authentication is now in use at run-time.

What to do next

Restart Internet Information Service.