首页 新闻 赞助 找找看

诡异Server Error in '/' Application.

0
悬赏园豆:80 [已关闭问题] 关闭于 2011-07-05 13:09

发布网站时遇到的诡异问题,在本地IIS和vs中运行都没有问题,可是一旦发布到服务器上就会出现这个问题,实在无解啊!!求助啊!!!!!!!!!!!!!

详细信息如下:

Server Error in '/' Application.

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   ereaProduct.Utility.SqlHelper.PrepareCommand(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, Boolean& mustCloseConnection) in F:\公司项目\阿尔商务\2011-06-23\ereaProduct\ereaProduct.Utility\SQLHelper.cs:138   ereaProduct.Utility.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) in F:\公司项目\阿尔商务\2011-06-23\ereaProduct\ereaProduct.Utility\SQLHelper.cs:698   ereaProduct.Utility.SqlHelper.ExecuteReader(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) in F:\公司项目\阿尔商务\2011-06-23\ereaProduct\ereaProduct.Utility\SQLHelper.cs:808   ereaProduct.DAL.Product.GetProductList(String user) in F:\公司项目\阿尔商务\2011-06-29\ereaProduct\ereaProduct.DAL\Product.cs:111   ereaProduct.BLL.ProductInfo.GetProductList(String user) in F:\公司项目\阿尔商务\2011-06-29\ereaProduct\ereaProduct.BLL\ProductInfo.cs:25   ereaProduct.proList.BindInfo() in F:\公司项目\阿尔商务\2011-06-29\ereaProduct\ereaProduct\manage\user_qy\proList.aspx.cs:32   ereaProduct.proList.Page_Load(Object sender, EventArgs e) in F:\公司项目\阿尔商务\2011-06-29\ereaProduct\ereaProduct\manage\user_qy\proList.aspx.cs:20   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   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

希望各位大牛给点儿帮助吧!!

问题补充:

而且我在本地测试也是链接的远程服务器上的数据库!

ly-newyear的主页 ly-newyear | 菜鸟二级 | 园豆:225
提问于:2011-07-01 17:18
< >
分享
所有回答(3)
0

这个貌似是数据库连不上。在数据库连接字符串上排查一下

镆铘 | 园豆:361 (菜鸟二级) | 2011-07-01 17:47
0

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. 

 

提示很清楚了,数据库连接不上。

检查web.config数据库IP和登录名密码是否写错了

卒子 | 园豆:588 (小虾三级) | 2011-07-01 22:35
0

很明显,楼主数据库不允许远程连接,是sql2005吗

打开数据库外围配置工具-->Surface area configuration for services and connections-->database engine-->Remot connections-->选择local and remote Connections-->选择第3个 TCP/IP AND name pipes

最后重新启动服务

readonly | 园豆:406 (菜鸟二级) | 2011-07-04 09:29
我在本地链接的也是远程的数据库啊!!根本没问题啊!!可放到服务器上就有问题了!!如果服务器数据库不允许远程链接,那么我在本地测试也会出问题啊!!我在本地测试也是链接的远程服务器上的数据库
支持(0) 反对(0) ly-newyear | 园豆:225 (菜鸟二级) | 2011-07-04 09:36
还有可能是 数据库连接字符串的设置问题
http://www.connectionstrings.com/
支持(0) 反对(0) readonly | 园豆:406 (菜鸟二级) | 2011-07-04 17:04
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册