The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
vCenter Single Sign On fails to connect to a Microsoft SQL instance (2039092)
- During the installation vCenter Single Sign On fails to access a remote Microsoft SQL 2008 R2 database.
- You may see the errors:
- Login failed for user 'xxx'
- No Database Name provided
- Multiple instances are running on the same Microsoft SQL Server
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.
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.