登录失败。该登录名来自不受信任的域 不能与 windows 身份验证一起使用。(Microsoft SQL Server ,错误：18452)

Question

环境：客户端与服务器位于父子域架构中。客户端加入子域，服务器（sql）：加入根域（父域）

问题描述：登录SQL数据库时偶尔会出现如下报错，请问是什么原因呢？



Answer 1

How do you trust domains? 

Answer 2

Hi cunlifang,

 

如果偶尔出现这种情况，很有可能是活动目录连接超时导致的，另外检查一下你的活动目录里面是不是设置了"Kerberos only"。

 

Best Regards,

Teige

 

---

MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:[e-mail]">[e-mail]</a>.

Answer 3

父子域之间是继承信任关系。

Answer 4

您好，“另外检查一下你的活动目录里面是不是设置了"Kerberos only"。请问是在AD域上检查还是sql数据库上检查？

Answer 5

AD域上面

---

MSDN Community Support<br/> Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact <a href="mailto:[e-mail]">[e-mail]</a>.

Answer 6

父子域之间是继承信任关系。

One way trust?