AzureFeeds - All your Azure feeds in one place.

Sponsors

Tuesday, November 24, 2009

ASP.NET Provider Scripts for SQL Azure

by jnak via Cloudy in Seattle on 11/24/2009 7:45:00 PM

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>)
email it!bookmark it!digg it!

Original Post: ASP.NET Provider Scripts for SQL Azure

Legal Note

The content of the postings is owned by the respective author. AzureFeeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on AzureFeeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us