App Scenario: ASP.NET to SQL Azure

- J.D. Meier, Paul Enfield.

Scenario

Scenario - Data 2 - ASP to SQL Azure - scenario.JPG

Solution

Scenario - Data 2 - ASP to SQL Azure - solution.JPG

Solution Summary Table

Area Note
Authentication * Users are authenticated against the ASP.NET app using forms authentication
* SqlMembershipProvider used for ASP.NET app authentication
* Users are mapped to SQL users with varying levels of privileges in the SQL database
* Connections to SQL Azure use the credentials of the mapped SQL user
* Connections to SQL Azure use connection strings stored in the web.config
Authorization * ASP.NET roles provided by SqlRoleProvider
* SQL users and roles used for ASP.NET app to SQL connections
Communication * Browser to app connections for non-secure transactions over HTTP port 80
* Browser user Authentication performed over port 443 SSL
* App to database connections occur over port 1433
* Secure TDS used for app to database communications
* SQL authentication occurs over secure TDS
* SQL connections are configured to screen IP addresses to expected client app addresses

Contributors and Reviewers

  • External Contributors and Reviewers: Adam Grocholski; Rudy Araujo
  • Microsoft: Scott Densmore; Vidya Vrat Agarwal


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

Comments

No comments yet.