I tried to implement the SqlMembershipProvider to connect to a database in Azure. I followed this tutorial (Forms-Based Authentication with SQL Azure). But there is a part, when it says replace the following line in your web.config file:

This is the configuration if you had your ASP.NET membership tables in a separate SQL Server Express file, locally, attaching that file to your SQL Server Express instance. This cannot be done in Azure like that - you'll have to put your ASP.NET membership tables into e.g. SQL Azure, and then reference that database from your config file
–
marc_sAug 12 '13 at 7:41