Looking for sample code to password protect pages using SQL 1

[markdmac]

I am hoping someone can point me in the direction of some sample code to add to my web site that will allow me to password protect some pages. I need to have a simple SQL database backend.

Visitors will enter an assigned USER ID and password on a login page. That will then bring them to another page which shows them a list of files. I need to be able to grab the User ID that was authenticated to be able to show the proper downloads for that customer.

I've used this reference in the past for classic ASP:

http://support.microsoft.com/kb/299987/EN-US/

but my pages are now ASP.Net and would prefer to try to learn a more modern approach.

I hope that helps.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[ca8msm]

In that case you'll want to use Forms Authentication as opposed to Windows Authentication. Here's a good starting point that will show you how it works:

http://msdn.microsoft.com/en-us/library/9wff0kyh.aspx

Mark,

Darlington Web Design[tab]|[tab]Experts, Information, Ideas & Knowledge[tab]|[tab]ASP.NET Tips & Tricks

 

[markdmac]

Unfortunatley I had already reviewed that link. The sample code doesn't use a SQL backend and while I am great as a scriptor I am lacking in development experience and am unsure how to modify the code to look to a database. There will be somewhere between 50-200 unique logins, so a database is really necessary for this application.

I hope that helps.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[MarkXaml]

If you have a pre-existing SQL Server database set up, use this for reference:

http://support.microsoft.com/kb/301240

If you're doing this from scratch with SQL Server, try this:

http://msdn.microsoft.com/en-us/library/ff649314.aspx

good luck!
Mark

 

[markdmac]

The second link seems to be what I am looking for Gryphon451. Thanks to you both for your efforts.



I hope that helps.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.