Forms Authentication Using SQL - Part 1
page 1 of 4
Published: 06 Oct 2003
Unedited - Community Contributed
This article provides some basic code to set up forms authentication within your web. Tested: ASP.NET 1.0 Included: Examples
by Jason N. Gaylord
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 21810/ 73

Have you ever wondered how sites authenticate users using forms? This article will explain how to by using ASP.Net and SQL 2000.

First, you need to prepare your computer to run the authentication. Be sure you already have IIS installed and running on a Windows 2000 (or better) computer or server. You also need to install the .Net Framework which is a free download available from Microsoft. After the .Net Framework is installed, you must configure IIS to run the framework properly. You can do so by going to IIS and setting the default user to ASPNET. More experienced users might want to edit the config files on the host to add additional users or permissions.

Secondly, you need to establish a database in SQL. If you do not have SQL, the SQL desktop engine (MSDE) is available as a free download from Microsoft. You can download this engine by going to and downloading the ASP.Net Community built Web Matrix. This will include steps to downloading MSDE. Once you have downloaded and installed your MSDE, you must setup a database.

View Entire Article

User Comments

Title: c# code   
Name: raj
Date: 2011-05-25 7:51:10 AM
Hi I want the code in C#, can u please send it?
Title: login authentication in   
Name: khyati
Date: 2009-07-13 1:09:45 AM
very good!
Title: Good stuff   
Name: jes
Date: 2007-04-16 3:31:45 AM
I got an error in this line
intResult = myCmd.Parameters( "RETURN_VALUE" ).Value
when i converted the code to c#.error is
intResult = myCmd.Parameters( "RETURN_VALUE" ).Value

how do i solve this
Title: Nice done but...   
Name: Edgar
Date: 2006-09-12 4:25:17 PM
I just have a little question. What if i want to know the username of the user in other wepages???.
Title: good   
Date: 2006-03-27 5:40:52 AM
easy to understand . lot of thanks
Title: Woooow   
Name: Eryk
Date: 2006-02-02 4:50:17 PM
Very Very Good.
Title: very good   
Name: Tuncay
Date: 2006-01-14 2:20:40 AM
thanks, this tutorial is very good.
Title: RE:   
Name: Bryan
Date: 2005-11-15 3:46:14 PM
Convert sqlCommand2.Parameters["RETURN_VALUE"].Value to a integer
Title: a question!   
Name: mohammad
Date: 2005-11-12 10:15:36 AM
hello ,thanx for this grat code ,but i have a prob!!
i have converted this code to C# and every thing is fine exept this statment
ntResult = sqlCommand2.Parameters["RETURN_VALUE"].Value;
it say can nit implicit convert from in to object ,
so can u help me in doning it in c#?
Title: excellent   
Name: jh
Date: 2005-10-03 5:21:58 PM
very nice work - thanks much!
Title: need an import though   
Name: jh
Date: 2005-10-03 5:14:52 PM
it neededs this at the top of the page though:

Imports System.Web.Security
Title: Perfect   
Name: Jacques
Date: 2005-07-29 4:49:45 AM
Thank you. Just what i needed.
Title: WellDone   
Name: Man
Date: 2005-06-16 10:29:39 PM
This was very well done and cover a whole lit of stuff that I actually was after!

Title: Gant   
Name: Gant Man
Date: 2005-05-28 11:30:31 PM

Just what I was after
Title: Good   
Name: Majun
Date: 2005-02-10 2:56:41 AM
Very Good.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-05-29 11:47:37 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search