SQL express dynamic port causes vCenter service fail to start


A friend called and asked me why his vCenter service failed to start after the server reboot. After spending some time in investigation, I finally found the root cause – he uses SQL express to host the DB. And the SQL server port changed to another after the server reboot, which led to the SSO service fail to function correctly.

This is how to troubleshoot:

1) Check if the SSO service is listening. If not stop the SSO service.

netstat -a | find “7444”

2) Disable the dynamic port and set 1433 in TCP port in SQL express (SQL Server Configuration Manager > TCP/IP > IP ALL > then remove port in Dynamic Ports), then restart the SQL express service.

3) 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

4) Replace the port number with 1433 in the db.url

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

5) Start the SSO service, then vCenter service.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s