Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Update vCenter Single Sign-On settings after you change the host name or port of the database server (2033516)

Details

When you change the host name or port assignment of the Single Sign-On database server, Single Sign-On fails and vCenter Server fails to start. This issue can also occur when you use SQL Server Express Edition, which is installed with Single Sign-On and vCenter Server. If SQL Server Express Edition is configured to use dynamic ports, the port assignment might change when you reboot the system. This problem occurs when the port is already in use by another service.

This article can also be used when you are moving or relocating the Single Sign-On Server to a new SQL database.

Solution

When you change the host name or port of the Single Sign-On database server, you must reconfigure Single Sign-On with the new host name or port.
  1. Stop the vCenter Single Sign-On server.

  2. Run the command:

    sso_server_folder\utils> ssocli configure-riat -a configure-db --database-host new_database_server --database-port new_database_port -m master_password

  3. Edit this text file to replace the port number with the new value in the line that begins with db.url=:

    sso_server_folder\webapps\lookupservice\WEB-INF\classes\config.properties

  4. Start the vCenter Single Sign-On server.
For information about how to find the current value of a dynamic port for SQL Server, see the Microsoft Knowledge Base article 823938.

Note: The preceding link was correct as of May 2, 2013. If you find the link is broken, provide feedback and a VMware employee will update the link.



Additional Information

For translated versions of this article, see:

Keywords

vCenter Single Sign-On, database server, port number, hostname

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 10 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 10 Ratings
Actions
KB: