登录来自不受信任的域，不能与Windows身份验证一起使用。 [英] The login is from an untrusted domain and cannot be used with windows authentication.

问题描述

嗨所有

创建ODBC连接到另一个域中的另一个服务器并从管理员用户连接成功但是当我尝试由另一个用户获取数据时它给了我以下错误

Hi all
after creating ODBC Connection to another server in another domain and connected success from administrator user but when I try to get data by another user it gives me the following error

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

我感谢您的帮助。

问候。< br $> b $ b

我尝试过：



我试图创建用户SDN在ODBC连接

I appreciate any help.
Regards.

What I have tried:

I have tried to create User SDN in ODBC Connection

推荐答案

阅读错误消息：

Read the error message:

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

这意味着您的SQL连接字符串正在尝试使用Windows身份验证，并且尝试访问SQL Server的计算机不在同一个网段。

例如：

That means that your connection string to SQL is trying to use Windows Authentication, and the computer trying to access SQL Server is not on the same network segment.
For example:

Data Source=GRIFF-DESKTOP\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True

要从不受信任的域访问SQL，您必须提供适当的SQL登录，而不是通过Windows进行身份验证：

To access SQL from a untrusted domain, you must supply an appropriate SQL login, rather than authenticate via Windows:

Data Source=GRIFF-DESKTOP\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=False;User Id=userid;Password=password

这篇关于登录来自不受信任的域，不能与Windows身份验证一起使用。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！