[研究] 套用 GCB 後資料庫連不上

[研究] 套用 GCB 後資料庫連不上

2021-09-10

********************************************************************************

'/' 應用程式中發生伺服器錯誤。

---

信號等待逾時。

描述: 在執行目前 Web 要求的過程中發生未處理的例外狀況。請檢閱堆疊追蹤以取得錯誤的詳細資訊，以及在程式碼中產生的位置。

例外狀況詳細資訊: System.ComponentModel.Win32Exception: 信號等待逾時。

原始程式錯誤:

在執行目前 Web 要求期間，產生未處理的例外狀況。如需有關例外狀況來源與位置的資訊，可以使用下列的例外狀況堆疊追蹤取得。

堆疊追蹤:

[Win32Exception (0x80004005): 信號等待逾時。] [SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - 信號等待逾時。)] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3331072 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +661 System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() +299 System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() +126 System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() +97 System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) +47 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +573 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89 System.Data.SqlClient.SqlDataReader.get_MetaData() +101 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +180 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +123 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2947 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +26 System.Web.UI.WebControls.ListView.PerformSelect() +125 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +134 System.Web.UI.WebControls.ListView.CreateChildControls() +81 System.Web.UI.Control.EnsureChildControls() +107 System.Web.UI.Control.PreRenderRecursiveInternal() +58 System.Web.UI.Control.PreRenderRecursiveInternal() +227 System.Web.UI.Control.PreRenderRecursiveInternal() +227 System.Web.UI.Control.PreRenderRecursiveInternal() +227 System.Web.UI.Control.PreRenderRecursiveInternal() +227 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3671

---

版本資訊: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.8.4330.0

********************************************************************************

解決：

Windows Defender 防火牆，「允許的應用程式」

SQL Server Windows NT - 64 Bit 的「網域」要打勾，就正常了。

(完)