出现错误:用户未与受信任的SQL Server连接相关联
问题描述：
你好，
我已经在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............ :)