当前位置: 代码迷 >> ASP >> 初学ASP,不懂网站如何连不上数据库
  详细解决方案

初学ASP,不懂网站如何连不上数据库

热度:57   发布时间:2012-05-12 15:39:31.0
初学ASP,不懂网站怎么连不上数据库,请指教
环境vs2008 sql2000 iis6
网页方面的代码应该都对,是老师给的,数据库根据老师的要求建了一个char数据库,users表
create table Users
(
  Username varchar(50) primary key,
  Password varchar(50) not null
)
网页是关于在线聊天室 这个表用于存注册信息的
全站有
login.aspx login.htm 
global.asax
main.aspx
charcontent.aspx
register.aspx
现在我想试试老师的网站效果,却在注册界面点注册时出问题了:
“/”应用程序中的服务器错误。
--------------------------------------------

用户 '20120501-1040\ASPNET' 登录失败。 
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 

异常详细信息: System.Data.SqlClient.SqlException: 用户 '20120501-1040\ASPNET' 登录失败。

源错误: 


行 44: string ConnectionString = ConfigurationManager.ConnectionStrings["Chat"].ConnectionString;
行 45: SqlConnection conn = new SqlConnection(ConnectionString);
行 46: conn.Open();
行 47: String Sql = "Select * From Users WHERE UserName='" + UserName.Text + "'";
行 48: //SqlCommand对象用来执行数据库命令
 

源文件: c:\Inetpub\wwwroot\Register.aspx.cs 行: 46 

堆栈跟踪: 


[SqlException (0x80131904): 用户 '20120501-1040\ASPNET' 登录失败。]
  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +821651
  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
  System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
  System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
  System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172
  System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381
  System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
  System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357
  System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30
  System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
  System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
  System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
  System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
  System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
  System.Data.SqlClient.SqlConnection.Open() +111
  Register.btnRegister_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\Register.aspx.cs:46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
  System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
  相关解决方案