Hi everyone,

We recently moved our Kentico infrastructure onto Windows Azure + SQL Azure and were having lots of problems with our sites going offline intermittently. I finally found a solution, and wanted to post it here in case anyone else is having the same issue.

After moving our databases onto SQL Azure, we start experiencing regular website outages that seemed to fix themselves after short (10-15 minute) periods. The error logs in Kentico were giving us the following error:

Page '/ (en-US)' not found.'

We were also getting some variations on page not found, default alias path not found, etc.

Looking closer at the Windows Server Event Viewer, we noticed lots of transport level connection errors with SQL Azure. Finally, we found the following article:

http://www.structuretoobig.com/post/2010/02/03/SQL-Azure-Transport-Level-Error.aspx

The solution they suggested here worked for us. Just append to the end of your connection string:

Pooling=false;

Everything has been running smoothly since then. No more connection problems.

Hope some people find this useful.