App Volumes existing SQL Port change

[mathewdsa]

Hi. Is there a way to change the default SQL port number of 1433 on an existing App Volumes installation? We need to migrate to a new SQL server and the standard for us is to use something other than the default. I know how to cut the App Vol managers over to the new DB server so that's no problem but I have to have it connect on the new port to the new server.

I already went to the registry and the HKLM\Software\WOW6432Node\Cloudvolumes\Manager and tried editing the server string to be SERVER,PORT   or SERVER:PORT and both still keep 1433.

Does anyone know how to change this on an existing installation?

Thanks

[sdtslmn]

you can modify the configuration file 

c:\Program Files (x86)\CloudVolumes\Manager\config\database.yml

[mathewdsa · Accepted solution]

Hi. I see only the http and https ports. I don't see a field to change the port for SQL.

I also opened a case with VMware and they warm that there is a possibility of unpleasant consequences to editing in place. Apparently I have to remove and reinstall and at the time of installation enter server as SQLSERVER,PORT format. Then it will go to the port I need.