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.
Procedure
- Using an account with administrator privileges, log in to the IaaS Windows server that hosts the Manager Service.
- In , stop the VMware vCloud Automation Center service.
- 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
- In each file, locate the <connectionStrings> section.
- Replace
Integrated Security=True;
with
User Id=database-username;Password=database-password;
- Save and close the files.
ManagerService.exe.config
Web.config
- Start the VMware vCloud Automation Center service.
- Use the
iisreset
command to restart IIS.