The system administrator can create the database manually using VMware-provided scripts.

.NET 4.5.1 must be installed on the SQL Server host.

Use Windows Authentication, rather than SQL Authentication, to connect to the database.

Verify the database installation prerequisites. See IaaS Database Server Requirements.

Download the IaaS database installer scripts from the vCloud Automation Center Appliance by navigating to https://vcac-va-hostname.domain.name:5480/installer/.

1

Navigate to the Database subdirectory in the directory where you extracted the installation zip archive.

2

Extract the DBInstall.zip archive to a local directory.

3

Log in to the Windows database host with sufficient rights to create and drop databases sysadmin privileges in the SQL Server instance.

4

Review the database deployment scripts as needed. In particular, review the settings in the DBSettings section of CreateDatabase.sql and edit them if necessary.

The settings in the script are the recommended settings. Only ALLOW_SNAPSHOT_ISOLATION ON and READ_COMMITTED_SNAPSHOT ON are required.

5

Execute the following command with the arguments described in the table.

BuildDB.bat /p:DBServer=db_server;
DBName=db_name;DBDir=db_dir;
LogDir=[log_dir];ServiceUser=service_user;
ReportLogin=web_user
Database Values

Variable

Value

DBServer

Specifies the SQL Server instance in the format dbhostname[,port number]\SQL instance. Specify a port number only if you are using a non-default port. The Microsoft SQL default port number is 1433. The default value for DBserver is localhost.

DBName

Name of the database. The default value is vcac..

DBDir

Path to the data directory for the database, excluding the final slash.

LogDir

Path to the log directory for the database, excluding the final slash.

Service User

User name under which the Manager Service runs.

ReportLogin

User name under which the Web services run.

The database is created.