出现错误:用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。
源码如下:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e) {
SqlConnection Conn=new SqlConnection();
Conn.ConnectionString="server=localhost;database=pubs;uid=sa;pwd=''";
Conn.Open();
SqlCommand Comm=new SqlCommand("select * from Authors ",Conn);
SqlDataReader dr=Comm.ExecuteReader();
dg.DataSource=dr;
dg.DataBind();
Conn.Close();
}
</script>
<asp:DataGrid id="dg" runat="server" />请问怎么解决?
谢谢
源码如下:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e) {
SqlConnection Conn=new SqlConnection();
Conn.ConnectionString="server=localhost;database=pubs;uid=sa;pwd=''";
Conn.Open();
SqlCommand Comm=new SqlCommand("select * from Authors ",Conn);
SqlDataReader dr=Comm.ExecuteReader();
dg.DataSource=dr;
dg.DataBind();
Conn.Close();
}
</script>
<asp:DataGrid id="dg" runat="server" />请问怎么解决?
谢谢
将这句代码:
Conn.ConnectionString="server=localhost;database=pubs;uid=sa;pwd=''";
改成:
Conn.ConnectionString="server=localhost;database=pubs;uid=sa;pwd=";
即可..
这样不行?
Conn.ConnectionString="server=localhost;database=pubs;uid=sa;pwd=sa";
那就跟楼上一样的
http://www.focusbbs.com/ArticleView/2005-4-27/Article_View_2136.Htm注意,改了以后,最好重起一下服务器,如果能重启一下系统就更好.....