App Scenario – ASP.NET Forms Auth to SQL Azure

- J.D. Meier, Paul Enfield.

Scenario

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

Solution

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.

Analysis

Contributors and Reviewers

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

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

Comments

No comments yet.