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.

1. Created website in Azure
2. Created SQL db in Azure
3. Allowed my IP to access Azure SQL via "firewall"
4. Changed web.config connection string back to standard (not use configSource=) 4.1 added Azure SQL connection string into web.config including "MultipleActiveResultSets=True;". 4.2 verify providerName="System.Data.SqlClient" is still in connection string <add tag. 4.3 Added <customErrors mode="Off"></customErrors> 4.4 Changed key="AutoMigrateDatabase" to value="True"
5. Added "MultipleActiveResultSets=True;" to Azure dashboard connection string as per StackOverflow.
6. Ran update-database (locally with laptop configured to point to Azure SQL db via Rock connection string.)
7. Download "the publish profile" from Azure
8. Right click RockWeb, and choose "Publish Web Site" 8.1 Import profile (one time) 8.2 Did not check "Execute Code First Migrations" option in setting (could not get it to work) 8.3 Restart website in Azure