ASP.NET Provider Scripts for Microsoft SQL Azure

If you want to use ASP.NET Providers (membership, role, personalization, profile, web event provider) with SQL Azure, you'll need to use these scripts or aspnet-regAzure.exe tool to setup database. Currently the only provider which isn’t supported on SQL Azure is session state provider. Its advisable to use Microsoft SQL Server 2008 R2 Management Studio Express […]

If you want to use ASP.NET Providers (membership, role, personalization, profile, web event provider) with SQL Azure, you'll need to use these scripts or aspnet-regAzure.exe tool to setup database. Currently the only provider which isn’t supported on SQL Azure is session state provider. Its advisable to use Microsoft SQL Server 2008 R2 Management Studio Express (SSMSE) to connect to SQL Azure and using Query window to run scripts. (if you already have SSMS 2008 installed, you can use that as well, just connect from Query window itself, not Object Explorer as that’ll fail). Note: Use SQL Server Authentication with following credentials:

Server name: <servername>.database.windows.net
Login: <username>@<servername>)