Click here to Skip to main content
13,901,142 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


42 bookmarked
Posted 9 Jul 2008
Licenced CPOL

ASP.NET Membership - Part 1

, 9 Jul 2008
Rate this:
Please Sign up or sign in to vote.
Step-by-Step guidelines to setup ASP.NET Membership Provider using VS 2005 / SQL Server 2005.


Many ASP.NET developers face problem in setting up membership providers and using built-in login controls. So here is a simple How-To / basic steps to setup register and login features of a site using ASP.NET Membership and Login Controls.


A bit familiarity with ASP.NET and Visual Studio 2005 is required. I will try to be simple. My local development machine which has VS2005, Microsoft SQL Server 2005 and .NET Framework 2.0. First we will develop this web application locally and then will deploy it on a webhost. We will be using SqlMembershipProvider and login controls.

Note: The Downloadable code has master page use also which is not mentioned here. But it is easy to understand whats going on when you look at the code.

Setting Up Site UI

  1. Start VS 2005.
  2. Create a New ASP.NET Web Application (File->New->Project->ASP.NET Web Application(C#)
  3. Add two new webForms - namely login.aspx, Register.aspx


  1. Drag and drop a Login Control from VS Toolbox onto login.aspx.
  2. Set these two properties for the login control you just added: CreateUserUrl="~/Register.aspx" --- CreateUserText="New User? Register Here!"


  1. Drag and drop a CreateUserWizard(CUW) Control on to Register.aspx.
  2. Set these properties for CUW you just added:
    ContinueDestinationPageUrl="~/login.aspx" LoginCreatedUser="False"


  1. Drag and drop LoginStatus and LoginName status on Default.aspx


Set up you web.config as below . I will explain it later what we are doing in it.

<?xml version="1.0"?>
<remove name="LocalSqlServer"/>
<!--<span class="code-comment">Replace yourConnectionString here with that which points to your database 
<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;
Initial Catalog=TestDB;Integrated Security=SSPI;Persist Security Info=True"/>
<add name="LocalSqlServer" connectionString="YourConnectionString"/>
<compilation debug="false" />
<authentication mode="Forms">
<forms name=".TestAuth" loginUrl="~/login.aspx" defaultUrl="~/Default.aspx"></forms>
<deny users ="?"/>
<membership defaultProvider="MyAspNetSqlMembershipProvider">
<add name="MyAspNetSqlMembershipProvider"

type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, 
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"












<location path="Register.aspx">
<allow users="*"/>

connectionStrings Section: What we are doing here is removing any reference to connection string LocalServer which might be there by default in machine.config and adding a new one. Note the YourconnectionString. The value might change depending on the connection string pointing to your database.

authentication Section: We are using here Forms authentication. We have give a name to authentication cookie, set the loginUrl and defaultUrl attributes. Nothing real fancy.

authorization Section: Here we are denying access to anonymous users. So they will be direct to our the login page that we have set in loginUrl.

membership Section: First we have set the defaultProvider attribute to the provider name to which we want our login controls to point by default. We have tag so it will remove any membership providers defined in machine.config. Then add our provider. See we have name set to MyAspSqlMembershipProvider just to differentiate. You can give any name. Then we have different settings which, i won't go in deep. But I would consider you to take a note of applicationName property. It is highly recommended to set this property to a unique name.

location Section : Setting path="Register.aspx" and will allow any user to access our Register.aspx page. We need to state this explicitly as we are denying anonymos access to our site as mentiod in authorization section.

The Site front-end is all set. Now lets look at setting up the Database.

Setting up Membership Database

We are going to use the default ASP.NET membership database schema. I will be writing a seperate article on how to use custom schema which will discuss on writing a custom membership provider.

  1. Create an empty database on your local SQL Server 2005. e.g. TestDB
  2. Run the aspnet_regsql.exe which is located in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\. (This might be different but the basic idea is it will be under your Windows directory whichever drive it may be.)
  3. Follow the wizard until you hit the step - "Select the Server and Database.
  4. Here select your Server and authentication mode as per your setting with the SQL Server.
  5. Database - from the dropdownlist, select the database you created in step 1 above.
  6. Successful message should show up.

Testing the Setup on Development Machine

Note: You have to set the appropriate connection string to this newly created database in your web.config as mentioned above.

So now if everything is setup correctly we can go ahead and test what we have done so far. Run your application from VS 2005. You will be sent to login.aspx. Now there are no users as of now. So first click on the New User? link and you will be sent to register page. Create a new user. Once the user is successfully created, once again you will be sent to login.aspx. Now login using the user you just created. On successful login you will taken to default.aspx. It will show you a LogOut button and the name of the user logged in.

Moving onto your Webhost

For the testing purpose I got a free webhosting account from Here are the steps I followed:

  1. First, detached my database TestDB.mdf from the SQL Server and uploaded it on to webhost using their database upload facility.
  2. Secondly, I attached my uploaded Database to their SQL Server 2005 Express. (Note I had SQL Server 2005 on local dev machine.)
  3. Uploaded all my files to the host machine.
  4. Changed the connection string in my web.config with the one that webhost company provided me for my database.
  5. Test the site and it should work.

Points of Interest

These are very basic steps. Nothing fancy and there are couple of advance articles around which you can go through. Post me comments if any problem. I will be writing part II with some more advance topics.

Useful Resources:

  1. Screenshots setting up database:
  2. Why to always set applicationName for membership provider:
  3. Free ASP.NET webhosting :


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

GeneralControll page access Pin
fergara29-Aug-08 12:50
memberfergara29-Aug-08 12:50 
GeneralRe: Controll page access Pin
gsark2-Sep-08 10:59
membergsark2-Sep-08 10:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web02 | 2.8.190306.1 | Last Updated 9 Jul 2008
Article Copyright 2008 by gsark
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid