Server Error in '/' Application. erro:40

来源:互联网 发布:交换机端口重启命令 编辑:程序博客网 时间:2024/06/01 20:06

数据库连接时,出现Server Error in '/' Application. erro:40

解决方法: 

方法一:配置错误

在网站目录下的Web.config里,连接数据库ip地址、数据库帐号、密码,可能没写好。

我是因为改了SQL默认端口,然后我把 " Data Source=IP " 里的IP直接用"点"代替。

举例:<add key="DBPlatformManager" value="Data Source=.; Initial Catalog=数据库名DB; User ID=明文帐号; Password=明文密码; Pooling=true"/>

方法二:权限错误

1.我的电脑 -- 右键 -- 管理 --用户管理 -- 用户 , 看看ISURE等用户是否启用。

2.在文件存放物理路径找到文件夹,给文件夹everyone用户权限。

Stack Trace: 

[SqlException (0x80131904): Unable to open the physical file "D:\users\Kevin\Downloads\网站\渗透测试演练系统\SQL注入攻击实验田VS2008版\SQL注入攻击实验田VS2008版\App_Data\AnalysisDatabase.mdf". Operating system error 5: "5(Access is denied.)".An attempt to attach an auto-named database for file D:\users\Kevin\Downloads\网站\渗透测试演练系统\SQL注入攻击实验田VS2008版\SQL注入攻击实验田VS2008版\App_Data\AnalysisDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4890587   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover) +247   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +1349   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +225   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +431   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117   System.Data.SqlClient.SqlConnection.Open() +122   Login_In.BtnLogin_Click(Object sender, EventArgs e) in d:\users\Kevin\Downloads\网站\渗透测试演练系统\SQL注入攻击实验田VS2008版\SQL注入攻击实验田VS2008版\Login_In.aspx.cs:41   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565


0 0
原创粉丝点击