Azure and ASP Authentication

[Zaaid]

Im am converting an application to be used with an Azure database. I am having some issues with ASP membership though. I have found some articles on this but not really what I am doing. The problem I am having now is I am using a Migrator.NET console application to do database Migrations. My first migration sets up the ASP membership parts using the following code.\[code\]// Install Membership and Roles to the database with the Asp.Net installer.SqlConnectionStringBuilder connectionBuilder = new SqlConnectionStringBuilder(connection.ConnectionString);SqlServices.Install(connectionBuilder.InitialCatalog, SqlFeatures.Membership | SqlFeatures.RoleManager, connection.ConnectionString);\[/code\]This causes the InstallCommon.sql error.I found this article from another post.http://www.hanselman.com/blog/Intro...lesAndUserProfileOnSQLCompactAndSQLAzure.aspxI installed the Microsoft.AspNet.Providers package but that's where I get stuck.Now I'm getting the error "The database connection string has not been set."I have a connection string setup in a db.config file which worked before I added the new package. Does the connection string need to be somewhere else now? Is there a better way to solve this issue?