Can I use ASP.NET Membership in Windows Azure Web Roles ?

ASP.NET Membership can be used from Windows Azure Web Roles, however it will require some tweaking since SQL Azure does not support the USE statement which the ASP.NET Membership database relies on.

If you have an existing ASP.NET Membership database you will need to modify it, see this guide for details.

If you are building a new site, Microsoft has provided a modified script to create the Membership database in SQL Azure – here.