ASP.NET Provider Scripts for SQL Azure

If you want to use the ASP.NET Providers (membership, role, personalization, profile, web event provider) with SQL Azure, you’ll need to use the the following scripts or aspnet-regAzure.exe tool to setup the database: http://support.microsoft.com/default.aspx/kb/2006191

Currently the only provider which is not supported on SQL Azure is the session state provider.

Personally, I like using SSMS 2008 R2 to connect to SQL Azure and using the Query window to run the scripts. (if you already have SSMS 2008 installed, you can use that as well, just connect from the Query window itself, not the Object Explorer as that will fail)

Note: I use SQL Server Authentication with the following credentials:

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s