.Net SqlClient Data Provider Msg 0 Level 11 State 0.

Applies to: SQL Azure Database V12.
 

Problem Description.
 

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, Line 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 attempts.

Cause.

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.


Solutions/Workarounds.


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 article:

Transient Fault Handling (Building Real-World Cloud Apps with Azure)

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.