Changing vSphere 5.5 SQL Port

[gimp]

What needs to be done to enable a static port for SQL in vSphere 5.5, instead of the dynamic port?
I found some info on the intarwebs regarding vSphere 5.1, but the commands listed do not exist in 5.5 (ssocli, 5.5 has instead(?) ssolscli.cmd)

We need to get a static port so that we can manage it with our SQL management server, and we don't want to open a huge hole in our firewall.

I know how to change the SQL port, but then SSO breaks and I'm not sure what else... so I know there are some additional steps but I cannot find what they are.

 

[peanuthead]

According to Jackie Chen:

1. Reconfigure the SSO connection

C:\Program Files\VMware\Infrastructure\SSOServer\utils\ssocli configure-riat -a configure-db –database-host servername –database-port 1433 -m SSO_Admin_Password

2. Replace the port number with 1433 in the db.url

notepad C:\Program Files\VMware\Infrastructure\SSOServer\webapps\lookupservice\WEB-INF\classes\config.properties

3. Start the SSO service, then vCenter service.

This may help too.
http://kb.vmware.com/selfservice/mi...nguage=en_US&cmd=displayKC&externalId=2045528

 

[gimp]

I found some info on the intarwebs regarding vSphere 5.1, but the commands listed do not exist in 5.5 (ssocli, 5.5 has instead(?) ssolscli.cmd)

According to Jackie Chen:

1. Reconfigure the SSO connection

C:\Program Files\VMware\Infrastructure\SSOServer\utils\ssocli configure-riat -a configure-db –database-host servername –database-port 1433 -m SSO_Admin_Password

2. Replace the port number with 1433 in the db.url

notepad C:\Program Files\VMware\Infrastructure\SSOServer\webapps\lookupservice\WEB-INF\classes\config.properties

3. Start the SSO service, then vCenter service.

This may help too.
http://kb.vmware.com/selfservice/mi...nguage=en_US&cmd=displayKC&externalId=2045528

ssocli does not exist with vSphere 5.5.

 

[gimp]

So apparently it is just as easy as changing to a static port in SQL Server Configuration Manager and then restarting all services (or just rebooting the server)?