用户“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>

哪里有问题?

你确定连接字符串是"Data Source=SONG;Initial Catalog=Northwind;User ID=sa;Password=sa))^"; ?后面那个))^没看懂,是密码?
我们写的话都是"server=.;database=Northwind;uid=sa;pwd=sa;"

汗。。这是mssql啊。。你sa密码是sa么??或者你没装mssql。。百度HI聊