How to specify an alternative port for the vRealize Automation IaaS database server in VMware Cloud Foundation 3.0.1 and higher

Products

• VMware Cloud Foundation

Issue/Introduction

This article describes how to change the Microsoft SQL Server port for the vRealize Automation IaaS database when deployed through VMware Cloud Foundation 3.0.1 and higher.

Environment

VMware Cloud Foundation 3.5.x
VMware Cloud Foundation 3.0.x

Resolution

1. SSH to the SDDC Manager appliance as the vcf user.
2. Switch to the root user by issuing the su - command.
3. Open /opt/vmware/vcf/commonsvcs/conf/application.properties with a text editor and change the value for vra.mssql.port to the desired port number for your vRealize Automation IaaS database server.

For Example:

​vra.mssql.port=10433 

Note: For VMware Cloud Foundation 3.7.2 and onwards, the file path is opt/vmware/vcf/commonsvcs/conf/application-prod.properties

Note: If this entry does not exist, add it to the end of the file with the appropriate port specified.

4. Restart the Common Services by issuing the following command:

systemctl restart commonsvcs

5. Login into the SDDC Manager UI and start the vRealize Automation deployment from Administration > vRealize Suite.

Note: After this change, the vRA validation will show a warning about unsuccessful MSSQL authentication. However, this can ignore it and proceed with the deployment.