VMware Horizon Community
mathewdsa
Enthusiast
Enthusiast
Jump to solution

App Volumes existing SQL Port change

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

Reply
0 Kudos
1 Solution

Accepted Solutions
mathewdsa
Enthusiast
Enthusiast
Jump to 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. 

View solution in original post

Reply
0 Kudos
2 Replies
sdtslmn
Enthusiast
Enthusiast
Jump to solution

you can modify the configuration file 

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

 

Reply
0 Kudos
mathewdsa
Enthusiast
Enthusiast
Jump to 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. 

Reply
0 Kudos