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.

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.

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

Restart Internet Information Service.