Installing vCenter Single Sign-On fails with the error: The TCP/IP connection to the host 192.168.1.104, port 1433 has failed

search cancel

book

calendar_today

VMware vCenter Server VMware vSphere ESXi

Symptoms:

Cannot install VMware vCenter Single Sign-On (SSO)
Installing SSO fails after entering the database information
After you enter the database information, such as the database name, port, RSA_DBA, and RSA_USER credentials, during the SSO installation and then click Next, you see an error indicating you to review the vm-sso-javalib.log file
In the vm-sso-javalib.log file, you see the error:

Failed to established connection :com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.1.104, port 1433 has failed.

VMware vCenter Server 5.1.x
VMware vSphere ESXi 5.1

This issue occurs if you are using SQL Express 2005 edition which, by default, does not have ports specified in the SQL Configuration Manager.

To resolve this issue, you must ensure that the SQL Express edition is listening on port 1433.

To ensure that the SQL Express edition is listening on port 1433:

Click Start > All Programs > Microsoft SQL Server > SQL Server Configuration Manager to open SQL Configuration Manager.
Click Client Protocols in the left pane.
In the right pane, right-click TCP/IP and click Properties.
Ensure that Default Port is set to 1433 and Enabled is set to Yes.
In the right pane of SQL Configuration Manager, right-click Protocols for SQLEXP_VIM and click Properties.
Ensure that the IP address and correct ports are specified for IP1, IP2, and IPALL.
Restart the SQL Server service for the changes to take effect.

Also, ensure that the firewall is either stopped or has an exceptions for both the database and vCenter Server ports.

thumb_up Yes

thumb_down No