Welcome Guest! To enable all features please Login or Register.
Profile: nick.clark
Name: nick.clark Offline
Joined: Wednesday, February 29, 2012(UTC)
Last Visit: Thursday, March 1, 2012 8:56:45 PM(UTC)
Number of Posts: 1
[0.00% of all post / 0.00 posts per day]
Thanks Given: 0 (View Thanks)
Thanks Received: 5
Thanked Posts: 1
Community Reputation Received:
View All Posts by User
Topic: How to Use Azure SQL   Go to last post
Posted: Wednesday, February 29, 2012 10:31:26 PM(UTC)
I struggled to setup YAF using Azure SQL. The only resource I could find was a blog post titled “Yet Another Forum (YAF) for Windows Azure” (http://www.blasoft.pl/blog/?p=496&lang=en), but the post only hinted at how to take a current release and use Azure SQL.

The solution ended up being straight forward. 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/ )
2. Create an Azure SQL database to store YAF
3. 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 (http://sqlazuremw.codeplex.com/) to copy the local YAF database to Azure.

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

This approach was much more successful than trying to manually modify the sql install scripts.