How to load .Net Membership and Role Capabilities on a SQL Server database

When you incorporate the Membership and Role capabilities to your ASP.Net project, Visual Studio configures a database connection that assumes you are using SQLSERVEREXPRESS.
However, most of the time you probably want to deploy your application in SQL Server 2005/2008, to do this you can use the ASP.NET SQL Server Setup application.
It provides a wizard that is very easy to use.

To open the Wizard, go to the Start Menu and click on the Visual Studio 2010 folder, then go to Visual Studio Tools and click on Visual Studio 2008 Command Prompt

Type: aspnet_regsql

The wizard will guide you, upon completion all the necessary database schema and stored procedures are loaded and ready for you to program your application in ASP.Net using the features provided by the Membership objects.

Below are some screenshots of the wizard in action.