Question

VS2010,C#的SQL2008数据库连接总是说实例失败，求解。

web.config
<connectionStrings>
<add name="ConnectionString" connectionString="server=KU\\SQLEXPRESS;database=mydata;uid=mysy;pwd=123456;"/>
</connectionStrings>

cs里的onload。一直提示实例失败。
string ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
Label1.Text = con.ServerVersion;
Label1.Text += con.State;

}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
Label2.Text = "state:" + con.State.ToString();
con.Close();

}

Answer 1

1.先检查SQL Server的服务是否开启
2.试着在C#代码里Open其它库试试

Answer 2

看看你的mysy用户有没有对应的访问权限 或者你先用sa试试

Answer 3

再添加using System.Data.SqlClient