First time trying to deal with users logging in with ASP.net and haven't had much experience with it with other things. From searching, I am seeing things like Asp.Net MVC Membership Provider. Is this a built in thing?
Is there any good online guides for this?
Take a look at the ASP.NET Provider Model. The MembershipProvider is a provider in the built-in provider model for handling users and you can download the source code of the default providers to look at how they are implemented.
If you want to install the default provider databases on a sql server, you can run Aspnet_regsql.exe from the command line to do so.
The great thing about the provider model is that it is very straightforward to write your own providers by deriving from the abstract base classes and use them in an application. You need only implement the methods that you need.
Here's a tutorial that walk you through creating the required database schema in sql express, it also explains what you need to do to move to other sql data sources. It explains how to setup users in forms authentication mode so that you can use role based authorization etc
http://www.asp.net/learn/moving-to-asp.net-2.0/module-08.aspx
You can use the ASP.NET membership features with MVC if you'd like. Are you wanting to use it with MVC or not? Scott Mitchell has a great tutorial that has several parts teaching many of the things one would want to know to get a website up and running. The built in Membership works well for basic situations but can become a pain as one wants to start adding more information to the user's profile.