SqlServer2008:[用户登录失败,用户不与可信的sql server连接关联] [英] SqlServer2008: [log in fail for user, the user is not associate with trusted sql server connection]
问题描述
你好shifu和专业人士,
我是sql server的新手,希望你们能帮助我!我的问题如下:
问题: 我有一个错误调用sql server不可信的用户连接。
ConnectionString:
Hi there shifu and pros,
i'm new to sql server, hope you guys can help me! my problem at below:
Problem: i'm having an error call sql server untrusted user connection.
ConnectionString:
Dim connection As New SqlConnection("Data Source=192.168.1.24,1433;Network Library=DBMSSOCN;Initial Catalog=TOTO2.MDF;User ID=MSC-03-PC\MSC-03;Password=")
*我正在使用窗口身份验证用户登录,因此我的声明中没有密码连接字符串。
服务器名称: MSC-03-PC\SQLEXPRESS
经过测试的解决方案但仍然无效:
i尝试按照此处的说明 http://support.microsoft.com/kb/555332 [ ^ ],但仍然保持相同的错误(不受信任的用户连接)。
*i'm using window authentication user to log in so don't have password inside my declaration of connectionstring.
ServerName: MSC-03-PC\SQLEXPRESS
tested solution but still won't work:
i try to follow the instruction from here http://support.microsoft.com/kb/555332[^], but still remain the same error(untrusted user connection).
推荐答案
您将作为服务器的密码。
尝试
http://www.connectionstrings.com/sql-server-2008 [ ^ ]
确定你需要使用的connectionString。
You are giving " as password to the server.
Try
http://www.connectionstrings.com/sql-server-2008[^]
to determine what the connectionString is you need to use.
添加集成安全性= SSPI而不是用户名和密码。
Add Integrated Security=SSPI instead of the username and password.
这篇关于SqlServer2008:[用户登录失败,用户不与可信的sql server连接关联]的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!