Уже замучил всех знакомых и незнакомых, так что остаётся только бросить клич в народ.
Есть 2 сайта, живующие на VPS. Вэб-сервер и SQL-сервер находятся на одной машине. ASP.NET Битрикс.
Ошибок масса, возникают "сами по себе" и часто когда один сайт не видит Сервера БД, второй прекрасно работает...
Что можете порекомендовать, если сервер вдруг свалился с такой радостью:
А что делать, чтобы он не падал с этим делом?
Ещё раз повторю, есть целый "букет заболеваний" с которым совершенно непонятно что делать....
Есть 2 сайта, живующие на VPS. Вэб-сервер и SQL-сервер находятся на одной машине. ASP.NET Битрикс.
Ошибок масса, возникают "сами по себе" и часто когда один сайт не видит Сервера БД, второй прекрасно работает...
Что можете порекомендовать, если сервер вдруг свалился с такой радостью:
Код |
---|
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: Line 6: void Application_Start(object sender, EventArgs e) Line 7: { Line 8: BXApplicationHelper.ApplicationStart(this); Line 9: } Line 10: Source File: c:\inetpub\wwwroot\bitrixnet\web\Global.asax Line: 8 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) +6244425 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +6259519 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +181 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +6260362 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +6260328 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +354 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +703 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +54 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +6261592 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +81 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1657 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +88 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6265031 System.Data.SqlClient.SqlConnection.Open() +258 Bitrix.DataLayer.BXSqlConnection.Open() +46 Bitrix.DataLayer.BXSqlConnection.CheckConnectionReady() +151 Bitrix.DataLayer.BXSqlCommand.CheckConnectionReady(Boolean stateCheck) +63 Bitrix.DataLayer.BXSqlCommand.ExecuteNonQuery() +54 Bitrix.Services.BXSqlLogProvider.WriteMessage(BXLogMessage message, DateTime occured) +676 Bitrix.Services.BXSqlLogProvider.LogMessage(BXLogMessage message) +308 Bitrix.Services.BXLogService.LogAll(BXLogMessage message, Boolean autoFlush) +142 Bitrix.Services.BXLogService.LogAll(String title, String message, BXLogMessageType messageType) +62 Bitrix.BXApplicationHelper.ApplicationStart(HttpApplication app) +52 ASP.global_asax.Application_Start(Object sender, EventArgs e) in c:\inetpub\wwwroot\bitrixnet\web\Global.asax:8 [HttpException (0x80004005): 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.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +4170257 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +205 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +336 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +350 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +382 [HttpException (0x80004005): 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.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11301302 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4338644 Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927 |
А что делать, чтобы он не падал с этим делом?
Ещё раз повторю, есть целый "букет заболеваний" с которым совершенно непонятно что делать....