book
Article ID: 305826
calendar_today
Updated On:
Environment
VMware vCenter Server 5.1.x
Cause
By default, the installer tries to access default MS SQL port 1433. However, only the default instance of SQL Server uses this port. By default, all SQL named instances use a dynamic port.
Resolution
To resolve this issue, set the port for the instance to a static port.
To set the port for the instance to a static port:
- Open the Microsoft SQL Server Configuration Manager.
- Navigate to SQL Server Network Configuration > Protocols for the instance name.
- Double-click TCP/IP.
- Click the IP address tab and scroll to the bottom where you see the dynamic port used by the instance.
- Change the port to a static port.
Note: If it is a dynamic port, it may change if the server is rebooted or if the service is restarted. VMware recommends manually setting a static port number for the instance.
- Restart the SQL instance to apply the change.
Note: From the SSO installer, you do not to specify the port anywhere. The instance accesses the database located in the instance using the configured port.