用户登录失败：用户未与可信的sql server连接关联？

We have an access front-end tied to a sql server 2005 back end. We have no trouble with any users accessing the interfaces with the exception of one. When trying to interact with the interfaces we get a SQL Server Connection Error telling us that the user is not associated with the trusted sql server connection. We are use mixed mode authentication so that is not the problem. We also thought it may be the computer itself, but the user gets the same error on multiple computers. Any suggestions?

我们有一个访问前端绑定到SQL Server 2005后端。除了一个用户之外,我们对访问接口的任何用户都没有问题。当尝试与接口交互时,我们得到一个SQL Server连接错误,告诉我们用户没有与可信的sql server连接相关联。我们使用混合模式身份验证,这不是问题。我们还认为它可能是计算机本身,但用户在多台计算机上获得相同的错误。有什么建议?

3 个解决方案

#1

Unexpected characters in the username?

用户名中的意外字符?

#2

Where we see it the user password has changed after login.

我们看到它的用户密码在登录后发生了变化。

Fix: log out and back in. Or lock the PC and unlock.

修复:退出并重新登录。或者锁定PC并解锁。

This way, you re-auth against AD and the NT login token is refreshed/renewed.

这样,您可以对AD重新进行身份验证,并刷新/续订NT登录令牌。

#3

Have you verified the actual account that is connecting? I've found on several occasions the authenticating account is a service account or something other than I intended. Include the intended domain to be sure. I've been caught by local admin vs domain admin as well.

您是否验证了正在连接的实际帐户?我已经多次发现身份验证帐户是服务帐户或其他我想要的帐户。包括目标域以确定。我也被本地管理员和域管理员抓住了。

Also fire up the SQL profiler and see what transactions are actually taking place.

同时启动SQL事件探查器并查看实际发生的事务。

#1