Forms Authentication Using SQL - Part 1: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Forms Authentication Using SQL - Part 1

page 1 of 4

Published: 06 Oct 2003

Unedited - Community Contributed

Abstract
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
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 30142/ 169

Article Contents:

Overview

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 www.asp.net/webmatrix/ 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

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 5 and 1 and type the answer here:

User Comments

Title: login authentication in asp.net
Name: khyati
Date: 7/13/2009 1:09:45 AM
Comment:
very good!

Title: Good stuff
Name: jes
Date: 4/16/2007 3:31:45 AM
Comment:
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: Good
Name: Ajay Gaikwad
Date: 12/12/2006 2:29:25 AM
Comment:
quite good

Title: very good
Name: alpa
Date: 12/2/2006 6:27:31 AM
Comment:
It is very fine

Title: Nice done but...
Name: Edgar
Date: 9/12/2006 4:25:17 PM
Comment:
I just have a little question. What if i want to know the username of the user in other wepages???.

Title: good
Name: ANTONY LEO EDEL
Date: 3/27/2006 5:40:52 AM
Comment:
easy to understand . lot of thanks

Title: Woooow
Name: Eryk
Date: 2/2/2006 4:50:17 PM
Comment:
Very Very Good.

Title: very good
Name: Tuncay
Date: 1/14/2006 2:20:40 AM
Comment:
thanks, this tutorial is very good.

Title: RE:
Name: Bryan
Date: 11/15/2005 3:46:14 PM
Comment:
Convert sqlCommand2.Parameters["RETURN_VALUE"].Value to a integer

Title: a question!
Name: mohammad
Date: 11/12/2005 10:15:36 AM
Comment:
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: 10/3/2005 5:21:58 PM
Comment:
very nice work - thanks much!

Title: need an import though
Name: jh
Date: 10/3/2005 5:14:52 PM
Comment:
it neededs this at the top of the page though:

Imports System.Web.Security

Title: Perfect
Name: Jacques
Date: 7/29/2005 4:49:45 AM
Comment:
Thank you. Just what i needed.

Title: WellDone
Name: Man
Date: 6/16/2005 10:29:39 PM
Comment:
This was very well done and cover a whole lit of stuff that I actually was after!

Thanks!

Title: Gant
Name: Gant Man
Date: 5/28/2005 11:30:31 PM
Comment:
Thanks

Just what I was after

Title: Good
Name: Majun
Date: 2/10/2005 2:56:41 AM
Comment:
Very Good.

Product Spotlight