用户“sa”登陆失败
来源:百度知道 编辑:UC知道 时间:2024/09/20 07:08:21
运行时提示“用户代码未处理SqlException”
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=SONG;Initial Catalog=Northwind;User ID=sa;Password=sa))^";
conn.Open();
Label1.Text = "ok";
}
-----------------------------------------
web.config中的代码
<connectionStrings>
<add name="NorthwindConnectionString" connectionString="Data Source=SONG;Initial Catalog=Northwind;User ID=sa;Password=sa))^"
providerName="System.Data.SqlClient" />
</connectionStrings>
哪里有问题?
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=SONG;Initial Catalog=Northwind;User ID=sa;Password=sa))^";
conn.Open();
Label1.Text = "ok";
}
-----------------------------------------
web.config中的代码
<connectionStrings>
<add name="NorthwindConnectionString" connectionString="Data Source=SONG;Initial Catalog=Northwind;User ID=sa;Password=sa))^"
providerName="System.Data.SqlClient" />
</connectionStrings>
哪里有问题?
你确定连接字符串是"Data Source=SONG;Initial Catalog=Northwind;User ID=sa;Password=sa))^"; ?后面那个))^没看懂,是密码?
我们写的话都是"server=.;database=Northwind;uid=sa;pwd=sa;"
汗。。这是mssql啊。。你sa密码是sa么??或者你没装mssql。。百度HI聊