System.Data.SqlClient.SqlException: 用户 'sa' 登录失败
做了一个SQL server 服务器远程监控系统,但在最后不能进入数据库,请高手帮看一下!
源错误: (31行)
行 29: SqlDataAdapter myDA = new SqlDataAdapter();
行 30: myDA.SelectCommand=selectCMD;
行 31: SqlConn.Open();
行 32: DataSet myDS = new DataSet();
行 33: myDA.Fill(myDS, "1");
堆栈跟踪:
[SqlException: 用户 'sa' 登录失败。]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
WSQLM.WebForm3.Page_Load(Object sender, EventArgs e) in d:\sql\wsqlm\webform3.aspx.cs:31
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
代码:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace WSQLM
{
/// <summary>
/// WebForm3 的摘要说明。
/// </summary>
public class WebForm3 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string connstring="Data Source="+Session["SqlServer"].ToString()+";"+"user id="
+Session["user"].ToString()+";"+"initial catalog="+Session["db"].ToString();
SqlConnection SqlConn=new SqlConnection(connstring);
SqlCommand selectCMD = new SqlCommand("SELECT * FROM "+Session["table"].ToString(), SqlConn);
SqlDataAdapter myDA = new SqlDataAdapter();
myDA.SelectCommand=selectCMD;
SqlConn.Open();
DataSet myDS = new DataSet();
myDA.Fill(myDS, "1");
DataGrid1.DataSource=myDS;
DataGrid1.DataBind();
SqlConn.Close();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}