用vs2005运行正常,用iis运行却出错,各位前辈帮帮我
用vs2005写的代码,在平台上运行是很正常的,可是当我用iis运行这个网站时,出现了下面的错误,各位前辈帮帮我.错误是:用户 '4D232D9C9196473\ASPNET' 登录失败。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: 用户 '4D232D9C9196473\ASPNET' 登录失败。
源错误:
行 25: PagedDataSource ps = new PagedDataSource();
行 26: sqlconn = myCon.getCon();
行 27: sqlconn.Open();
行 28: string sqlstr = "select a.*,b.* from tb_Card as a join tb_Module as b on a.ModuleID=b.ModuleID";
行 29: SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlstr, sqlconn);
源文件: c:\网站建设\mrBBS\mrBBS\Index.aspx.cs 行: 27
堆栈跟踪:
[SqlException (0x80131904): 用户 '4D232D9C9196473\ASPNET' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
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) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Index.dlBind() in c:\网站建设\mrBBS\mrBBS\Index.aspx.cs:27
Index.Page_Load(Object sender, EventArgs e) in c:\网站建设\mrBBS\mrBBS\Index.aspx.cs:20
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
--------------------编程问答-------------------- 以前也遇过,不知怎么搞定的,应该是IIS配置的问题~ --------------------编程问答-------------------- just sql connection error. are you using windows authentication to connect to sql ? you can add ASPNET account into sql by using sql management studio and grant right to it ,or just using sql authentication.. --------------------编程问答-------------------- 在你的企业管理器---安全性--登陆--新建登陆--增加ASPNET用户---服务器角色选种System Administrators---数据库访问把你要访问的数据库选中. --------------------编程问答-------------------- 检查一下数据库登录信息,
补充：.NET技术 , C#
