点F5运行程序,如果还报错The user is not associated with a trusted SQL Server connection. 打开SQL Server Configuration Manager,如果你装过多个sql server,写Data Source=(local);会不知道选哪个连接,所以你得写明白到底连接的是哪个。 从Start中选Run(运行)输入services.msc,查看你正在运行的sql server是那个 ...
上文中的连接字中包含有:Trusted_Connection=yes; 这就意味着连接将采用信任连接方式,但由于连接前没有用Windows组账号(在ASP环境中是访问IIS服务账号IUSR_计算机名,在ASP.NET环境中账号是ASPNET)登录至SQL Server 2000服务器, 也就是说没有建立一个信任连接(Trusted connection),当然,SQL Server 2000连接也不能够...
上文中的连接字中包含有:trusted_connection=yes; 这就意味着连接将采用信任连接方式,但由于连接前没有用windows组帐号(在asp环境中是访问iis服务帐号iusr_计算机名,在asp.net环境中帐号是aspnet)登录至sql server 2000服务器, 也就是说没有建立一个信任连接(trusted connection),当然,sql server 2000连接也不能够...
展开“Microsoft SQL Servers”,然后展开“SQL Server 组”。 右键单击要更改为“SQL Server 和 Windows”身份验证的服务器,然后单击“属性”。 在“SQL Server 属性”对话框中,单击“安全”选项卡,单击“SQL Server 和 Windows”,然后单击“确定”。 当提示您重新启动 SQL Server 服务时,单击“是”。 SQL Serve...
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.原因：A...
HResult 0x4814, Level 14, State 1 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Here is the sql server log immediately afterwards. 2012-08-13 22:14:24.52 spid53 Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Cop...
when trying to connect from SQL Server 2008 (on Windows Vista) to a SQL Server 2005 on another PC (with Windows 2003) I get the"Login failed for user ''. The user is not associated with a trusted SQL Server connection" error.
In addition to an extra space in the connection string, the other class of causes for this error message is an inability to resolve the Windows account trying to connect to SQL Server. This list is not intended to be exhaustive, but ...
SQL Server 2005: “Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'”. SQL Server 2000: "Login failed for user "(null)". Reason: Not associated with a trusted SQL Server connection". The errors listed above is very typical when deploy linked server with delegation. They actually are ...
现象:Login failed for user 'sss'. The user is not associated with a trusted SQL Server connection. 原因: SQL Server服务器没有启用混合认证,将认证方式从集成认证改为混合认证即可解