Hi Folks,

Hopefully, there is simple solution for the following:

1.) I have a 5,000+ record database in SQL Server 2005 that holds, among other things, a 'username' and 'password' info for each record.

2.) I'm using asp.net 2.0 in VB.NET. Not familiar with C#.

3.) I just want to create a simple login and protection of the pages---using the schema and data stored in my SQL Server 2005 database. Assuming it will use session state inproc.

Is this possible and can be done simply?

The built in .NET Membership Provider model information has many problems for us: we can't use the schema generated by the aspnet_regsql.exe utility, not willing to use SQL Server Express, nor do we want to create a new database or add more tables. We don't need ability for people to self-register, as this is taken care of over the phone! We don't need role management or other such functions.

Just an ability for someone to login to an .aspx page using a standard session cookie, be able to browse the various pages for about 30 minutes, and then log out. This was so simple in classic .asp. Surely, there must be a solution in .NET?

I have read the MSDN, ScottGus Blog, etc., but either the examples are C# (which not familiar), way overly complex for what we need, or do not provide examples of Visual Basic code that works with existing SQL Server 2005 database schema via the ASP.NET Membership Provider.

We tried using a 3rd party component (http://www.webxel-dw.co.uk/extension...px?ProductID=2) but it was a total disaster and kept resetting the session state after 3 minutes.

Does anyone have any idea on how to do this?

Thanks,

Chris