SQL Server 2008 Windows 身份验证登录错误:登录来自不受信任的域 [英] SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
问题描述
尝试使用 Management Studio 连接到 SQL Server 2008 实例时,出现以下错误:
When attempting to connect to a SQL Server 2008 Instance using Management Studio, I get the following error:
登录失败.登录来自不受信任的域,无法使用使用 Windows 身份验证.(Microsoft SQL Server,错误:18452)
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
我可以毫无问题地使用 SQL 身份验证登录.我突然收到这个错误.我打开了混合模式身份验证.
I can login using SQL Authentication without problem. I've been getting this error all of a sudden. I have Mixed Mode Authentication turned on.
有人有这方面的经验吗?
Does anyone have any experience with this?
附加信息:64 位版本的 SQL企业版在 Windows 2003 服务器上
Additional Info: 64-bit version of SQL Enterprise Edition On Windows 2003 Server
推荐答案
对我来说,这发生在我编辑了一个空白的 drivers/etc/hosts
文件,并为本地网站添加了一个条目时,但忽略添加127.0.0.1 localhost
For me, this happened when I edited a blank drivers/etc/hosts
file, and added an entry for a local website, but neglected to add 127.0.0.1 localhost
这篇关于SQL Server 2008 Windows 身份验证登录错误:登录来自不受信任的域的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!