Introduction

Most ASP.NET projects implement features like Login, Security, Password encryption, User Roles, Access rights, etc. Lot of code and logic goes into implementing all of this stuff.SQLMembership resolves all these concerns just by a few clicks and configurations and above all (which I like the most) without a single line of code. :)

Background

In this article, I will provide a complete walkthrough about using SQL Membership in ASP.NET projects. I hope you find this stuff beneficial.

Using the Code

SQL Membership is a wonderful way of interaction betweenASP.NET andSQL Server. SQL Membership provides 2 kinds of Authentication methods:

  1. Using SQL Server Membership database (Kind of Form Authentication)
  2. Using Local System authentication (Windows Authentication)

The process is relatively easy to implement. I will go step by step to show the implementation. Let's consider that you are going to develop an application from scratch, so here we go:

  1. First, we need to setup the SQL Membership database. In order to create that database, please follow the steps:
    1. Go to Windows Start menu>>All Programs>>Microsoft Visual Studio 2005/2008>>Visual Studio Tools and clickVisual Studio 2008 Command Prompt
    2. Type aspnet_regsql and press Enter key from the keyboard.

      1.png

    3. This will launch SQL Membership Wizard as follows. Click Next button to continue.

      2.png

    4. On the next screen select the first option to "Configure SQL Server for application services". Click Next to continue.

      3.png

    5. This screen is important as you will mention the Database information here. On the basis of that, table structures and other things will be created. You can use an existing database or create a new one.

      4.png

    6. After filling all the information click next and Finish. :) You guessed right, yourSQLMembership database is ready now.
  2. Now let's connect our ASP.NET Website application to this database. For this, first create an ASP.NET website in Visual Studio 2005/2008.
  3. Now open the Web.Config file for the project and add a well qualifiedConnection String for theSQL Server Membership database you are going to use.
    Collapse |Copy Code 
    <connectionstrings>
    <add name="abcdCS" connectionstring="
    Data Source=myserver\sqlexpress;Initial Catalog=just create database name;
    User ID=sa;Password=pass" 
    providername="System.Data.SqlClient" />
</connectionstrings>

    This Connection String will be used by theASP.NET Configuration forconnection with the database.

  4. After that, click on VS 2005/2008 Project menu>>ASP.NET Configuration

    5.png

  5. This will launch the ASP.NET Web Site Administration Tool. Here, you will test the databaseconnection, manage users, roles, permissions, etc.
  6. First click on the Provider tab.

    6.png

    Here you will be testing the database connection. Click on both the links one by one to test theconnectivity with database.

  7. Clicking the above links will show screen as mentioned below:

    7.png

    9.png

    Click the "Test" link in each screen to check the connection status.

  8. If your connection is successful, you will get a screen like this:

    8.png

So far so good. :) We are done with the connection part ofSQLMembership database with theASP.NET website application.

Now in order to select authentication types, create users, manage roles, and access rules, you need to see theSecurity tab.

10.png

In order to setup the SMTP settings, Application Settings, Debugging and Tracing settings, and default error page, you need to visit the Application tab.

About more reference to my blog ,link: http://blog.csdn.net/tristan_dong/article/details/8261716