This project is read-only.

App Scenario – ASP.NET Forms Auth to SQL Azure

- J.D. Meier, Paul Enfield.


Scenario - Web 2 - ASP Forms Auth to SQL Azure - scenario.JPG


Scenario - Web 2 - ASP Forms Auth to SQL Azure - solution.JPG

Solution Summary Table

Area Notes
Authentication * ASP.NET Azure application
* Authenticated with Forms Auth
* Users are stored in SQL Azure
* Authentication against user store occurs with SqlMembershipProvider
* Connections to SQL Azure occur as the application identity
Authorization * Application resources restricted by roles
* Roles stored in SQL Azure
* Role APIs provided by SqlRoleProvider
* Authorization to access SQL resources occurs in application coding
Communication * User credentials are protected over the wire with SSL
* Communication to SQL Azure occurs over a secure TDS connection
* SQL Azure connections are filtered based on IP screening configured using SQL Azure admin tools.


Contributors and Reviewers

  • External Contributors and Reviewers: Adam Grocholski; Kevin Lam; Rudy Araujo
  • Microsoft: Scott Densmore; Stephan Schackow

Last edited May 27, 2010 at 11:50 PM by paulenfield, version 4


No comments yet.