The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Logging into Microsoft SQL Server 2008 R2 fails with the error: The login is from an untrusted domain and cannot be used with Windows authentication (2031113)
On Windows 2008 R2, you install VMware vCenter Server Heartbeat 6.4 on two vCenter Servers and configure them to protect MS SQL Server 2008 R2 and vCenter Server 5.0, both of which are running on the same host.
If you try to login to the MS SQL Server Management Studio with the public hostname (the second hostname on the primary host) in Windows Authentication mode, you may experience these symptoms:
- Logging into Microsoft SQL Server 2008 R2 fails
- You see the error:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
A Windows security setting is preventing authentication with multiple hostnames.
Ensure that both the local hostname and public hostname can be correctly resolved on the primary host, then follow the Microsoft article 926642.
Note: When you input CNAME or DNS alias into the BackConnectionHostNames value field, specify Fully Qualified Domain Name (FQDN). For example:
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.