诡异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
希望各位大牛给点儿帮助吧！！
所有回答(3)
0
这个貌似是数据库连不上。在数据库连接字符串上排查一下
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和登录名密码是否写错了
0
很明显，楼主数据库不允许远程连接，是sql2005吗
打开数据库外围配置工具-->Surface area configuration for services and connections-->database engine-->Remot connections-->选择local and remote Connections-->选择第3个 TCP/IP AND name pipes
最后重新启动服务
我在本地链接的也是远程的数据库啊！！根本没问题啊！！可放到服务器上就有问题了！！如果服务器数据库不允许远程链接，那么我在本地测试也会出问题啊!!我在本地测试也是链接的远程服务器上的数据库
还有可能是 数据库连接字符串的设置问题
http://www.connectionstrings.com/
http://www.connectionstrings.com/
