Asp.NET and VS Forms Authentication for website

I need to design an authentication system for my website, which is ASP.NET. I am looking through a video walk through on how to do this the standard ASP.NET way. It creates a separate small database under the app_data folder, with all of the authentication info it needs. My concern is that I want the login to check a Users table from my actual external database (still internal to the domain), which has the usernames and passwords of people that will be viewing the site, and adding, editing and deleting from that database. The user info is logically tied into this external database for fields such as "created by", "modified by" etc...

So I am concerned that this tutorial is a waste of time unless somehow, after authentication, I can use that value to identify who is writing to records in the external/main database, and identify them in terms of the User in the external/main database. Somehow, these two databases need to both have the same exact user info, which seems odd to me.

I thought about just writing to both databases and making sure the values are always identical, but something seems a little hokey about that.

Any good ideas from people who, unlike me, actually know how to do this? Thanks.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Duy PhamFreelance IT ConsultantCommented:
Microsoft has described a very neat and basic about Forms Authentication in ASP.NET here: How To Implement Forms-Based Authentication in Your ASP.NET Application by Using C#.NET.

Check out the ValidateUser method in that link, you can easily see that we are able to customize it to do any kind of validation we want. By that, you can connect to your existing database and then validate entered Username/Password against your Users table.

The key part of Forms Authentication lies in cmdLogin_Click handler, where the authentication cookies are created to initiate a logged in session in your ASP.NET Application.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BobHavertyComhAuthor Commented:
I apologize for not seeing your solution earlier and I don't know why I missed it. Thank you very much.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.