The membership and roles providers used by ASP.NET by default are the SqlMembershipProvider and SqlRoleProvider, respectively, which serialize membership and roles information to a SQL Server database. Specifically, this information is stored in a variety of pre-defined tables and accessed through a number of pre-defined stored procedures. In order to use membership or roles with your application using the default providers you need to apply this pre-defined schema to your application's database.
The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database.
The Aspnet_regsql.exe file is located in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 folder on your Web server.
You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your SQL Server installation, and installing or removing the database elements for the membership, role management, profile, Web Parts personalization, and health monitoring features.
In this article we'll examine how to use this tool to apply the membership and roles services for the SqlMembershipProvider and SqlRoleProvider providers. This tool can be used both from the command-line and through the graphical wizard.
In the Previous articles i explained how to integrate ckeditor with asp.net, how to upload image to the server or application using Ckeditor , how to change or set width of ckeditor textbox area using asp.net, how to set or change height of Ckeditor textbox area using ASP.Net, integrate custom image uploader control with ckeditor using asp.net and many more about sql server.
Run the Aspnet_regsql.exe file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 folder on your Web server.
Select "Configure Sql Server for application services" option and Hit Next Button.
Choose Windows Authentication.
Enter Your Server Name like My-PC\Sqlexpress
After that Choose your Database from the dropdown.
After you have specified that database, click Next to review the changes that will be made. After previewing the changes click Next to install the schema. This will add the tables, views, and stored procedures needed by the SQL Server-based membership providers.
You are Done. Congratulations, Your Database is Succesfully Configured with membership Tables.