Server Error in '/' Application. erro:40【第二次修正140121】

最新推荐文章于 2020-01-08 15:44:48 发布

原创最新推荐文章于 2020-01-08 15:44:48 发布 · 1.9w 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#6878 #网站

网页专栏收录该内容

11 篇文章

订阅专栏

本文介绍了两种常见的SQL连接错误解决方案：一是配置错误，通常出现在Web.config文件中数据库连接字符串的设置上；二是权限错误，涉及用户账户启用及文件夹权限设置。

解决方法：

方法一：配置错误

在网站目录下的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用户权限。如下图。

以下是现实显示错误信息：

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5005406
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity) +341
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +129
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
   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) +33
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   Game.Kernel.DbHelper.ExecuteDataset(CommandType commandType, String commandText, DbParameter[] commandParameters) +267
   Game.Kernel.DbHelper.ExecuteDataset(String commandText) +50
   Game.Kernel.DbHelper.ExecuteObjectList(String commandText) +61
   Game.Data.NativeWebDataProvider.GetTopNewsList(Int32 typeID, Int32 hot, Int32 elite, Int32 top) +487
   Game.Facade.NativeWebFacade.GetTopNewsList(Int32 typeID, Int32 hot, Int32 elite, Int32 top) +61
   Game.Web.Index.BindNewsData() +66
   Game.Web.Index.Page_Load(Object sender, EventArgs e) +82
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   Game.Facade.UCPageBase.OnLoad(EventArgs e) +44
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1966

Version Information: Microsoft .NET Framework Version:4.0.30128; ASP.NET Version:4.0.30128.1

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

下面截图