Knowledge Base

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

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)

Details

On Windows 2008 R2, you install VMware vCenter Server Heartbeat 6.4.x and 6.5.x on two vCenter Servers and configure them to protect Microsoft SQL Server 2008 R2 and vCenter Server 5.x, both of which are running on the same host.
 
If you try to login to the Microsoft 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.

Solution

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:
  • hostname.mydomain.com
  • hostname_1.mydomain.com

Update History

04/22/2013 - Added vCenter Server 5.1 and Heartbeat 6.5 to Products

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

  • 8 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)
  • 8 Ratings
Actions
KB: