Hi,

I am very new to .Net and am trying to learn the ropes but everytime I try I get stumped. I am trying to do 2 things: 1) log a user in using an remote SQL 2000 server, 2) set 5 diffrent session variables once the username/password has been verified from the database.

My problem is two fold; I need a basic walk-through on how to configure the login control to work (or an effective way to log a user in), and I also need to learn how to retrieve data from the database upon verification of usrname/password and set certain fields from the database as session variables.

Can someone please assist me or point me in to the right direction?

I'm using VB.

 

I hope you're working with VS2005: Then this post is a good summary of ASP.NET 2.0 membership, roles and forms authentication. http://weblogs.asp.net/scottgu/archive/2006/02/24/438953.aspx 

Scroll down till you see this section "Authentication and Authorization". Here you'll find links who might be useful to you: "how to: Use Forms Authentication with SQL Server 2000 (with ASP.NET 2.0)"

 In order to work with sql membership providers, you need to set up the asp.net2.0 application services database. More info about that can be found over here: http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

I know it are a lot of links an reading material but all the articles are very nice and reading them will make this whole security concept more clearly to you!!

 Good luck ;)

Wim