title: Azure SQL Database Operation Timeout
body: <p>I have a shared hosting site "production" that works perfectly.  It has users and thus far I have no issues.</p>
  
  <p>I decided to created a test environment.  I created another <code>Azure</code> app and copied the code from my "production" site to this test site.  This happen today.  It has no users. I created a DB and I agreed to pay five bucks a month.  So this is not a free account. I uploaded my seed data which part of it was 40K rows of zip code.  That went fine without issues.</p>
  
  <p>However, when I use the site, I consistently get <code>timeout error</code>.  I can assure you that this is NOT because of usage. I increased the timeout from 30 to 90 in the connection string but that didn't make a difference.  There is no code difference between the production and test.  </p>
  
  <p>I have read many post about this but none helped.  Here are some samples:</p>
  
  <p><a href="https://stackoverflow.com/questions/34880198/the-wait-operation-timed-out-but-only-from-net-client">post1</a>  <a href="https://stackoverflow.com/questions/26756596/the-wait-operation-timed-out-in-sql-server">post2</a> <a href="https://stackoverflow.com/questions/31345154/system-componentmodel-win32exception-the-wait-operation-timed-out">post3</a> <a href="https://stackoverflow.com/questions/34306966/the-wait-operation-timed-out">post4</a> <a href="https://stackoverflow.com/questions/27291338/the-wait-operation-timed-out-win32exception-0x80004005-the-wait-operation-tim">post5</a> <a href="https://stackoverflow.com/questions/25094681/sqlclient-sqlexception-the-wait-operation-timed-out">post6</a></p>
  
  <p>Any ideas?</p>
  
  <pre><code>&gt; [Win32Exception (0x80004005): The wait operation timed out]
  &gt; 
  &gt; [SqlException (0x80131904): Timeout expired.  The timeout period
  &gt; elapsed prior to completion of the operation or the server is not
  &gt; responding.  This failure occurred while attempting to connect to the
  &gt; routing destination. The duration spent while attempting to connect to
  &gt; the original server was - [Pre-Login] initialization=27; handshake=25;
  &gt; [Login] initialization=0; authentication=0; [Post-Login] complete=3; 
  &gt; ]    System.Data.SqlClient.SqlConnection.OnError(SqlException
  &gt; exception, Boolean breakConnection, Action1 wrapCloseInAction)
  &gt; +2418094    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
  &gt; exception, Boolean breakConnection, Action1 wrapCloseInAction)
  &gt; +5694436    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
  &gt; stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +285   
  &gt; System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
  &gt; SqlCommand cmdHandler, SqlDataReader dataStream,
  &gt; BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
  &gt; stateObj, Boolean&amp; dataReady) +3731   
  &gt; System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58   
  &gt; System.Data.SqlClient.SqlDataReader.get_MetaData() +89   
  &gt; System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
  &gt; RunBehavior runBehavior, String resetOptionsString) +379   
  &gt; System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
  &gt; cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
  &gt; async, Int32 timeout, Task&amp; task, Boolean asyncWrite, SqlDataReader
  &gt; ds, Boolean describeParameterEncryptionRequest) +2064   
  &gt; System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
  &gt; cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
  &gt; method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task,
  &gt; Boolean asyncWrite) +375   
  &gt; System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
  &gt; cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
  &gt; method) +53   
  &gt; System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
  &gt; behavior, String method) +240   
  &gt; System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
  &gt; behavior) +41   
  &gt; System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
  &gt; +12    System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
  &gt; entityCommand, CommandBehavior behavior) +435
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/gz0la.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gz0la.png" alt="Usage Graph"></a></p>