出现错误:用户未与受信任的SQL Server连接相关联 [英] Getting Error : The user is not associated with a trusted SQL Server connection

问题描述

你好，

我已经在IIS上上传了我的网站.我已取消选中属性"->目录服务"中的异常访问.
我在另一台服务器上有数据库，在该服务器上我创建了一个用户"WEUSER"并获得了权限.
我已将此用户名和密码添加到我的连接字符串中.

但我遇到类似
的错误

Hello,

I have upload my web site on IIS. I have unchecked the anoynomous access from the Property->Directory Service.
I have database on the other server, on which i have created one user "WEUSER" and also given the permission.
I have added this username and password into my connection string.

But I m getting error like

System.Data.SqlClient.SqlException: Login failed for user : The user is not associated with a trusted SQL Server connection.

我也尝试过使用NT/NETWORK SERVICE.

请帮忙.

在此先谢谢您.

I have tried using NT/NETWORK SERVICE also.

Please help.

Thanks in advance.

推荐答案

您的连接字符串可能不正确.
检查正确的连接字符串此处 [ ^ ]

Your connection string might be incorrect.
Check for correct connection string Here[^]

问题是，当您安装SQL Server时，然后选择混合模式进行Windows身份验证的SQL Server身份验证.

寻求更多帮助

链接

希望对您有帮助.........:)

The problem is when you install SQL Server then select mixed mode for SQL Server authentication insted of Windows authentication.

See for more help

Link

I hope this may help u............ :)

这篇关于出现错误:用户未与受信任的SQL Server连接相关联的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！