Install YAF with Windows SQL Azure

The general steps are:

1. Create an Azure SQL database to use to store membership
2. Run Azure specific membership scripts to setup database http://lluisfranco.com/2011/05/18/using-asp-net-membership-in-sql-azure/
3. Create an Azure SQL database to store YAF
4. Create a local database in SQL Express 2008 R2 to store YAF
5. Modify db.config and change the “yafnet“ connection string to the local YAF database
6. In db.config add another connection string called “yafnetmembership” for the Azure membership database
7. Modify web.config to use the Azure membership database. This includes setting the membership, role, and profile default providers and setting those providers to use the "yafnetmembership” connection string.
8. Run YAF locally (I used Visual Studio) and go through the installation wizard (do not check the use “full text” index on the database step)
9. Shutdown the local YAF
10. Modify db.config and change the “yafnet“ connection string to the Azure YAF database
11. Use the SQL Azure Migration Wizard to copy the local YAF database to Azure.

Note: You will need to make sure you open the Azure SQL firewall.

Solution Provided by Nick Clark

You can find more detailed Guide here... http://sergiikram.wordpress.com/2012/10/15/install-yaf-net-on-windows-azure-sql-azure-the-complete-guide/