0

My domains actually trust each other because I have access from both sides and can log in with Sql authentication. But when I try to access it with windows authentication it gives the "Login failed. The login is from a Un- trusted domain and cannot be used with Windows authentication.

(Microsoft SQL Server, Error: 18452)" error. Plus the sql server accepts sql and windows auth.

Thanks

Prabhat Sinha
  • 1,520
  • 19
  • 29
Haruto
  • 1
  • 1
  • 1
  • 1
  • *can log in with sql authentication* - This just requires a route to the server and valid credentials; there is no domain based trust or negotiation involved. – Alex K. Aug 09 '16 at 13:16
  • See this question: https://stackoverflow.com/questions/18603696/trouble-connecting-to-sql-server-login-failed-the-login-is-from-an-untrusted-d/45333508#45333508 – Diogo Jul 26 '17 at 17:18

2 Answers2

3

It happened to me. In web.config, when I checked connectionString it was set to Integrated Security=true. Make Integrated Security=false if you are providing the username and password.

Baqer Naqvi
  • 5,162
  • 2
  • 43
  • 64
0

There are two ways to resolve this problem. One is to use RUNAS command. Another way to use credential manager in windows. The main problem here is your computer is in one domain and the SQL SERVER is another domain. SQL SERVER doesn't allow due to security issue. See Doc for more details

zhongxiao37
  • 917
  • 7
  • 16