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

• bet-597538

  Old Hand

  Points: 342

  More actions

  August 23, 2011 at 7:34 am

  #242740

  Hello,

  I met an issue while connecting to SQL Server (in domain B) from client (Windows Server 2008) (in domain A).

  Set in the "Credential Manager" proper account, but when I try to connect all I get is:

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

  I have to mention, that I don't have such issues connecting from Windows Server 2003 where in "Stored User Names and Passwords" looks very similar; one difference is DOMAIN\* in 2003 and *.DOMAIN in 2008.

  There would be no issue if I had to deal with just two domains, but we have several domain and I don't want to use separate SSMS instance for each one. Also, we have an application working in every domain and I need exactly one instance of this app to do my work.

  Shortly:

  X - client WS2003/WXP in domain(S) A

  Y - client WS2007/W7 in domain A

  Z - SQL Servers 2005/8 in domains B, C, D

  Connection from X to Z works fine

  Connection from Y to Z DOESN'T work at all returning above error message.

  RUNAS workaround won't work since I need to connect to more then one different domain at one time.

  Single change on SQL Server won't work as well since we have many servers in each domain.

  Do any of you had similar issue and solved it?

  Thank you!