• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Changing vSphere 5.5 SQL Port

G

gimp

[H]F Junkie
Joined
Jul 25, 2008
Messages
10,583
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.
 
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
 
j-sta said:
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)
Click to expand...

peanuthead said:
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
Click to expand...

ssocli does not exist with vSphere 5.5.
 
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)?
 
You must log in or register to reply here.
Back
Top