用户 'sa' 登录失败该用户与可信 SQL Server 连接无关联

显示全部楼层 · 2010-5-9 20:25:38

用vs2008登录asp系统，输入用户名和密码后，出现：
源错误:
行 23:
UsersManager um = new UsersManager();
行 24:
行 25:
int result = um.AdminLogin(txtUserName.Text, txtPassword.Text);
行 26:
if (result == -1)
行 27:
{

源文件: c:\Inetpub\wwwroot\ykt\admin\login.aspx.cs
行: 25
堆栈跟踪:
[SqlException (0x80131904): 用户 'sa' 登录失败。该用户与可信 SQL Server 连接无关联。]
ChinaVcv.DataAcessLayer.DBHelper2.OpenConnection() in F:\订单\已做代码\医院一卡通\dbhelper\file\DataAcess.cs:158
ChinaVcv.DataAcessLayer.DBHelper2..ctor() in F:\订单\已做代码\医院一卡通\dbhelper\file\DataAcess.cs:69
ChinaVcv.DataAcessLayer.Session.OpenSession() in F:\订单\已做代码\医院一卡通\dbhelper\file\dalinstancel.cs:586
ChinaVcv.DataAcessLayer.Session.GetSession() in F:\订单\已做代码\医院一卡通\dbhelper\file\dalinstancel.cs:232
ChinaVcv.DataAcessLayer.SessionFactory.OpenSession() in F:\订单\已做代码\医院一卡通\dbhelper\file\dalinstancel.cs:47
ChinaVcv.BusinessLogicLayer.Manager`1.IsExist(String SQL) in F:\订单\已做代码\医院一卡通\dbhelper\file\dbamanager.cs:828
LBW.BLL.Role.UsersManager.AdminLogin(String username, String password) in F:\订单\已做代码\医院一卡通\LBW.BLL.Agent\role\users.cs:322
temp_login.ImageButton1_Click(Object sender, ImageClickEventArgs e) in c:\Inetpub\wwwroot\ykt\admin\login.aspx.cs:25
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
vs2008以浏览器方式打开login.aspx，登录asp.net医院一卡通系统，用的是sql2005数据库，已经用sa登录了啊。。

千问 · 2010-5-9 20:25:38

用这句话 Integrated Security=SSPI; 替代uid=;pwd=;

千问 · 2010-5-9 20:25:38

看下sa用户能直接连sql么，下面是相应的问题介绍网址

用户 'sa' 登录失败 该用户与可信 SQL Server 连接无关联

用户 'sa' 登录失败该用户与可信 SQL Server 连接无关联