How to Publish to Azure

Here are the steps I took to get Rock running on Azure. This is not to say there is not another path, but only that this was the path I took after several other attempts.

Manual / Non-Source Control Setup

0. Install a Windows Azure SDK
1. Azure -> Add new website "CUSTOM CREATE":
   1. Page 1 - Create Web Site
      1. URL: rockchms
      2. DATABASE: "Create a new SQL database"
      3. DB CONNECTION STRING NAME: "RockContext"
      4. Next.
   2. Page 2 - Specify database settings
      1. NAME: rockchmA8V3QtxcL (was default)
      2. SERVER: New SQL database server
      3. SERVER LOGIN NAME: RockUser
      4. SERVER LOGIN PASSWORD: ***************
      5. Complete.
2. Azure, select website (to see dashboard)
   1. click "Download the publish profile"
   2. click CONFIGURE tab, add ";MultipleActiveResultSets=true" to connection string as per StackOverflow.
3. VS, edit web.config
   1. Changed web.config <connectionStrings> section not use configSource=)
   2. add to <connectionStrings> section <add name="RockContext" ... with connection string from previous step.
   3. add <customErrors mode="Off"></customErrors>
   4. change key="AutoMigrateDatabase" value to "True"
4. VS, Right click RockWeb, and choose "Publish Web Site"
   1. Import profile (one-time)
   2. Settings: check "Use this connection string at runtime..."
   3. Settings: UN-check "Execute Code First Migrations" (could not get it to work)
   4. Publish
5. Done. Window loads with working Rock in Azure.