.Net SqlClient Data Provider Msg 0 Level 11 State 0.
Applies to: SQL Azure Database V12.
I was already connected to the AdventureWorksLT database on a SQL Azure
Database server when I tried to execute a query against the database and
received the following error message:
.Net SqlClient Data Provider: Msg 0, Level 11, State 0,
The connection is broken and recovery is not possible. The client driver
attempted to recover the connection one or more times and all attempts failed.
Increase the value of ConnectRetryCount to increase the number of recovery
A few minutes ago I had started scale up process from Basic tier to Standard S0
tier and the process was still in progress when I tried to execute the query.
While scaling from one tier to another connections are closed, open
transactions when the scale process start are rolled back, and new connections
are not allowed.
It is expected that applications handle these events with a retry logic. For
more information about how to implement this strategy please read the following
Transient Fault Handling (Building Real-World Cloud Apps with Azure)