Login error using virtual name

• rupengzhao

  SSC Enthusiast

  Points: 130

  More actions

  August 9, 2012 at 11:23 pm

  #259826

  Hi,

  I have a default SQL 2008 R2 instance on a server ABC1, and I setup a virtual DNS name ABC2 that points to the IP address of ABC1.

  However, I cannot connect to ABC2 with windows authentication using SSMS on the server ABC1 itself, although I can do so from anywhere else. The error message I received was:

  Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

  It seems very weird.

  Very much appreciate if anyone can offer any help.

  Thanks in advance.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  August 9, 2012 at 11:56 pm

  #1524212

  By default on the same machine Names Pipes protocol is used.

  Disable Names Pipes or force TCP protocol.

• rupengzhao

  SSC Enthusiast

  Points: 130

  More actions

  August 10, 2012 at 12:04 am

  #1524215

  Thanks Suresh for the quick response.

  I disabled Named Pipes and Shared Memory, only TCP/IP is enabled. Restarted the server.

  Still have the same problem, even if I specify TCP/IP as the Network protocol when using SSMS to connect.

  Rupeng