IIS, SQL Server & Umbraco


I wonder if anyone can help me out, we have a Umbraco installation running:

  • OS: Microsoft Windows Server 2016 Standard, v10.0.14393 Build 14393

  • SQL Server: SQL Server 2016 Standard Edition, v13.0.1728.2

  • Umbraco: v7.3.4

The server had a scheduled reboot this morning at 5 am, from then, we've can't get the application back online, every time we go to the site we get the following error:

[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed before completion of the operation or the server is not responding.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +2442598
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction) +5766516
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +285
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4162
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
System.Data.SqlClient.SqlDataReader.get_MetaData() +89
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) +409
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) +2031
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +911
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +64
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +240
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +12
StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +68
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +14
1.MoveNext() +265

I can't see any updates have run and looked at the windows update logs there isn't anything there neither.

I've tried

  • Restarting the server
  • Restarting the application pool.
  • Restarting IIS
  • Increase timeout to 6000.

If anyone can shed any more light on this it would be great.

asked on Stack Overflow Dec 23, 2019 by WebDevB • edited Dec 23, 2019 by marc_s

1 Answer


You need to increase the command timeout from the default of 30 seconds. It's a property of the DbCommand object.

See here:


I'd suggest you change it to the value 0 (i.e. unlimited)

answered on Stack Overflow Dec 24, 2019 by Greg Low

User contributions licensed under CC BY-SA 3.0